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 |
|
khushi
Starting Member
5 Posts |
 Posted - 2009-01-19 : 23:34:13
|
| If in a SSIS Package we have 3 data flow tasks and one data flow task fails because SQl Server from which we are importing data gets fails then is whole package also gets fail ?How we can run another adat flow tasks?Please tell me the solution. |
|
|
khushi
Starting Member
5 Posts |
Posted - 2009-01-20 : 00:05:55
|
| Hi all please tell me the solution if anybody knows. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-20 : 02:41:01
|
| you want the package to continue even when one data flow fails? then set falipackageonfailure property of data flow task to false |
|
|
|
khushi
Starting Member
5 Posts |
Posted - 2009-01-30 : 23:29:06
|
| But I think this is property only works when there is problem in failure with any constraint but if sql server from which we are trying to cpy the data is not working then this property does not work even then ssis package fails to run. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-31 : 08:29:06
|
| whats the problem which is causing in source server? |
|
|
|
|
|
|
SSIS Package Problem