control ssis package execution

if i have multiples data flow tasts in a  ackage, and i want to make sure only i data flow is executed, how do i cntrol at job level.

July 12th, 2013 4:58pm

Hi,

I could not completely understand your exact requirement ,

but if want to handle package execution in such a way that only if all DataFlow tasks are executed , then simply setting all the precedence constaint link b/w DFT 's to On Success(Green color) will work - http://msdn.microsoft.com/en-us/library/ms141261.aspx

or 

if you care only about the execution of one DataFlow task and just want the completion of other DFT' s (irrespective of successful / failed execution result ) , then setting ForceExecutionResult  to success on other DFT 's will work - http://sathyadb.blogspot.in/2013/02/sql-server-integration-services.html

Free Windows Admin Tool Kit Click here and download it now
July 13th, 2013 2:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics