Custom logic in Script Task giving error at ReinitializeMetadata()

Jun 11, 2012 at 7:37 AM

Hi,

I have written code inside script task to iterate the logic for multiple tables. However I am getting error at ReinitializeMetadata() method just after setting the AccessMode of Destination. The error comes only in 2nd iteration. 1st iteration executes successfully. I have given details of this problem here (with my code) http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/daa4dcc8-7c61-4137-94e0-fb725c45c0f7

I tried to look for the solution at many places but nothing helpled. All my tables exists in database.

Please help me by pointing out the exact cause of this error.

Thank you.