SSIS Task to check for Null or empty string and fail Package

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I remember now that I created a script task to check the output variable and succeed or fail the package.

I believe?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I seem to recall having to create a variable.

Then in the EXEC SQL Task write to result set and do something with the parameter mapping.

There I created a Script task and based on the values fail or succeed the Package.

I believe that there is an example on MSQLTips.com.

Any ideas?

Thank you.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/