Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Timeout in SSIS Expand / Collapse
Author
Message
Posted Thursday, April 4, 2013 12:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 12:44 AM
Points: 230, Visits: 129
Hi,

I have developed a SSIS package in which it contains one execute SQL task,data flow task for retrieving data from oracle and push it to SQL and one more sql task. These all tasks are present in Sequence container.

We scheduled a job to run the ssis and it was running fine in dev but where as in Production for some reason it got stuck by 2 days and no error is being shown.

Is there any chance of setting the timeout for the entire package so that after that particular interval of time I would log the error as Timeout and send mail to the respective users.

Please help me in this regard.

Thanks in Advance.
Post #1438659
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse