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 2008 Forums
 SSIS and Import/Export (2008)
 execute sql task

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 tbl2
due 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.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -