Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Object variable

Author  Topic 

LearningSQLKid
Yak Posting Veteran

51 Posts

Posted - 2014-10-23 : 08:55:02
Hi Guys

I need a help. I have a foreach loop in my ssis package which iterates through the object variable. The object variable has only one column called tbl_name. In my foreach loop i pass tbl_name to execute sql task which truncates the table. ... all working fine so far. Now I want to do error halding.....Let say if error occurs i want to store tbl_name in another object variable ... not in database. For example if my object variable holds 10 tbl_name values and tbl 8,9 fails my 2nd object variable should only have these two values... is it possible , if yes then how can i achieve this ?

Thank you so much

Select Knowledge from LearningProcess

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-23 : 09:31:01
You'll need to write a script task for that. Define a variable to hold the failing table names. Pass that variable (read/write) along with the failed table name (read only)to the script. Concatenate the new table name to the end of the variable holding the failed table names.
Go to Top of Page
   

- Advertisement -