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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-07-11 : 07:21:56
|
| Hi,There is an insert sql inside the execute sql task.The insert is supposed to do several insert i.e.insert into tbl1 (field1, field2, etc) select field1, field2, etc from tbl2due to references, etc. sometimes one insert may not work BUT I would like the other inserts to work. Is there a setting in the execute sql task so that if one insert fails in the above statement, then it does not stop the ssis package? I would like it to continue.Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-11 : 12:49:15
|
| I think that if you use GO seperators between the statements, it will continue. Else you can put the statements in seperate tasks. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-07-11 : 13:43:29
|
| If you put that fail-able INSERT as its own separate task, just change the precedence constraint (workflow arrow) to On Completion. Whether it succeeds or fails it will still continue to the next task. |
|
|
|
|
|
|
execute sql task