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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:06 PM
Points: 5,032, Visits: 4,824
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: Today @ 6:18 AM
Points: 15,396, Visits: 13,123
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:06 PM
Points: 5,032, Visits: 4,824
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: Today @ 6:18 AM
Points: 15,396, Visits: 13,123
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