Is it possible for me to override this on a custom condition and start the package at an earlier task where it executed successfully
Ex:
Check pointing is enabled.
FTP task e Write to Staging Table e Write to Target table.
Assuming I am downloading XML file through FTP and writing to a table.
-
FTP Download is successful.
-
Read from XML file and write to Staging table task failed because of downloaded file is not a well formed XML.
Here, FTP task is completed successfully; it failed only in the second task. When I re-run the package; it starts from the second [Read from XML file and write to staging table] task because of check pointing.
Is it possible for me to restart from the FTP task on a custom condition where it executed successfully
SSIS Check pointing - Is it possible to override the point at which the package restarts on custom condition
ColinCJ
I *think* this is possible but you'll have to check it out. You can fool the package a bit by using a Sequence Container. Put the first two tasks into a Sequence Container and make the Sequence Container the unit of restart. You may have to pllay around with the setup of the tasks/container a little bit but I'm hopefult this will work.
-Jamie
GethWho
Actually I may have spoken too soon. I've just had a go at this and can't get it to work. Unfortunately I think you may be stuck.
I have comes across this problem before and as such raised the following request for enhancement (RFE) at Connect:
Execute a container regardless of checkpoint
(https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=126489)
I would appreciate your clicking through, voting, and adding a comment. The more people that ask for this feature the more likely we are to get it.
-Jamie
Fahad349
Thanks Jamie for your valuable time towards this issue.
-- Cyril Stanislaus Xavier