Reshedule SSIS Package & get back data on Package Failure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Reshedule SSIS Package & get back data on...

Reshedule SSIS Package & get back data on Package Failure

Rate Topic

Display Mode

Topic Options

Author

Message

bhushan_juare

Posted Thursday, September 27, 2012 4:15 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:14 AM
Points: 62, Visits: 358

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

cafescott

Posted Thursday, September 27, 2012 7:16 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:17 PM
Points: 109, Visits: 498

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 »

Permissions