Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, February 11, 2016 2:44 PM
Points: 4,843, Visits: 4,694
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Thursday, February 11, 2016 12:51 AM
Points: 15,023, Visits: 12,989
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 SQLKover.

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: Thursday, February 11, 2016 2:44 PM
Points: 4,843, Visits: 4,694
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Thursday, February 11, 2016 12:51 AM
Points: 15,023, Visits: 12,989
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 SQLKover.

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

Add to briefcase

Permissions Expand / Collapse