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 04, 2013 12:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 8:31 AM
Points: 188, Visits: 113
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