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.
| Author |
Topic |
|
LearningSQLKid
Yak Posting Veteran
51 Posts |
 Posted - 2014-10-23 : 08:55:02
|
| Hi GuysI 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 muchSelect 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. |
 |
|
|
|
|
|
Object variable