question

loktaurian avatar image
loktaurian asked

script task in SSIS fails

Experts, I am running into an issue with a set of my SSIS packages and need help on this. one of my SSIS package has a script component which refers a custom dll. This was developed using SQL BIDS (2008) and was then upgraded to SQL Server 2012 version using the upgrade wizard in the dev. environment. Everything works as expected in the upgraded version of the package. However, when this is deployed in prod, the SSIS package execution fails. But, when I open the package manually, re-build the script component and then try executing the package, the execution completes with out any issues. Any thoughts on how this can be sorted out ?
ssisscript-task
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
neeehar avatar image
neeehar answered
try setting up the delay validation to true(DLL's execute at run time not at build time( https://cygwin.com/cygwin-ug-net/dll.html)). Use TRY CATCH in script component.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.