July 9, 2013 at 8:20 am
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/
July 9, 2013 at 2:54 pm
Can you explain your scenario in a bit more detail?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 10, 2013 at 6:21 am
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/
July 10, 2013 at 1:42 pm
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply