March 30, 2011 at 4:50 am
hi ,
I am transfering my Datas from one source to 5 another destination and ı am using multicast operator in DataFlow component. But if anyone of parallel tasks have fails (like destination server is close) then package not running . But package must be run succesfully with error handling
Has anyone experienced this issue?
Thanks
March 30, 2011 at 8:25 am
You can use Checkpoints. But a package can be restarted only at the control flow level. You cannot restart a package in the middle of a data flow. To avoid rerunning the whole data flow, the package might be designed to include multiple data flows, each one using a different Data Flow task. This way the package can be restarted, rerunning only one Data Flow task. Therefore, in your case you can have 5 DFTs in a single package.
Here is the link for checkpoints: http://msdn.microsoft.com/en-us/library/ms140226.aspx
March 31, 2011 at 2:39 am
Thansk Ms.SSIS for your answer,
But I cant handle validation error. I can manage other error using OleDb Destination Error Output . if anyone of my destination servers is unavaible then the package is firstly checking validation of server avaibility then if one is fails then the package has fails
so what can I do to manage for this problem
March 31, 2011 at 3:47 am
Check the settings for FailPackageOnFailure and FailParentOnFailure.
If you want to write to several destinations while one of them may be unavailable, I think you should give each flow it's own dataflow. Otherwise it just won't run.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2011 at 8:14 am
Ms.SSIS (3/30/2011)
You can use Checkpoints. But a package can be restarted only at the control flow level. You cannot restart a package in the middle of a data flow. To avoid rerunning the whole data flow, the package might be designed to include multiple data flows, each one using a different Data Flow task. This way the package can be restarted, rerunning only one Data Flow task. Therefore, in your case you can have 5 DFTs in a single package.Here is the link for checkpoints: http://msdn.microsoft.com/en-us/library/ms140226.aspx
I used dynamic connection string and variables in my package. if I use checkpointing , variables do not work. And also checkpointing don't work with parallel dataflow, or I cant
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply