Hi,

I am new to SSIS and followed the steps in this article as it is to create the error handler. If I execute the error handler SQL task manually it...

Because this is just 1 step of the bigger process. I am doing a lot of processing of the data which requires SSIS. I just couldnt figure out which task...

I got my answer. Following is the link to it : http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/479dd6f9-b929-4276-8b03-204427b21453...if it can helpsomebody in future.

Thanks!

Jack,

I cannot use the Execute SQL Task or Data Flow Task for that matter because:

1. If I create a Variable with the dynamic SQL in it it fails coz my...

Thanks Jack! I got that part right now. Was pretty dumb huh!!!

But now I am struggling with another error. The code is working fine for simple queries like insert and...

Thanks Jack! That worked.

~SJ