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

Reshedule SSIS Package & get back data on Package Failure Expand / Collapse
Author
Message
Posted Thursday, September 27, 2012 4:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 28, 2013 2:48 AM
Points: 64, Visits: 367
Hi All,
I have scheduled SQL Job composed of several steps My first task is to get customer data from 1st server and dumb it in excel file as soon as i get data i sent mail saying "Data has been Dumb Successfully" and do same for remaining 3 server. All 4 servers are located apart from one another.
Sometime because of N/W isssue i won't be able to copy data into a file from a server resulting failure. Now, I want to design SSIS package where I can do all above said things and when package got falied at particular stepe while collecting data into a file, I want to restart package and get the a file which was not copied because of N/W issue...

Thanks & Regards,
Bhushan
Post #1365128
Posted Thursday, September 27, 2012 7:16 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, December 8, 2014 6:20 AM
Points: 162, Visits: 723
You can establish check points in your package. This will enable you to restart the package and bypass the steps that have already been successfully done.


Post #1365232
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse