Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is it possible to Rollback the Transaction for a single load is you SSIS Package or the Job that runs the package? Expand / Collapse
Author
Message
Posted Tuesday, July 9, 2013 8:20 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, July 27, 2014 6:10 AM
Points: 4,179, Visits: 4,260
Is it possible to Rollback the Transaction for a single load is you SSIS Package or the Job that runs the package or is the only way it will roll back if an error is encountered?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1471647
Posted Tuesday, July 9, 2013 2:54 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:02 PM
Points: 13,334, Visits: 10,201
Can you explain your scenario in a bit more detail?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1471863
Posted Wednesday, July 10, 2013 6:21 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, July 27, 2014 6:10 AM
Points: 4,179, Visits: 4,260
For instance I have a job that basically stops loading records. If I kill it it messes up the data if I do not let it finish because of the way that the code in the package was written.

This job was executing the 5th step from 5:00 AM until I finally killed it 12 hours later.

I doubt that there is a way to roll back if I stop the job?


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1472076
Posted Wednesday, July 10, 2013 1:42 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:02 PM
Points: 13,334, Visits: 10,201
Welsh Corgi (7/10/2013)
For instance I have a job that basically stops loading records. If I kill it it messes up the data if I do not let it finish because of the way that the code in the package was written.

This job was executing the 5th step from 5:00 AM until I finally killed it 12 hours later.

I doubt that there is a way to roll back if I stop the job?


You'd have to incorporate such logic in the packages itself.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1472329
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse