SSIS Package with CLR Trigger

I am trying to run an SSIS package that calls a stored procedure that calls a CLR trigger. I am getting the following error:

Error: SSIS error code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. OLE DB entry available.
Source : "Microsoft SQL Server Native Client 11.0" HResult: 0x80004005
Description : "The metadata could not be determined because the" UPDATE blah SET field = value "statement in the" sp_MyProc "procedure calls a CLR trigger.".
Error : Unable to retrieve target column descriptions from SQL command parameters.

I am running SQL Server 2014 but the package was created in 2005. We recently updated our servers and migrated old packages, so we are seeing this issue now. The package worked fine in SQL Server 2005.

+3


source to share





All Articles