Reshedule SSIS Package & get back data on Package Failure

  • [font="Courier New"]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[/font]

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply