Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhushan_juare
Starting Member
45 Posts |
 Posted - 2012-09-27 : 06:15:44
|
| 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 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-27 : 07:10:23
|
| You can include a checkpoint in the package and have it restart. Take a look at this page to see if that gives you enough information: http://msdn.microsoft.com/en-us/library/ms140226.aspxIf you are using foreach loop to traverse through the list of servers, be sure to look at the support article link at the bottom of that page. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-27 : 10:30:59
|
| are you using some type of control table to log details of fetched files?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bhushan_juare
Starting Member
45 Posts |
Posted - 2012-09-28 : 01:40:35
|
| Stored procudure got excuted on a Server to collect data then SQL Job run to get all data in one file.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-28 : 10:37:00
|
| we implemented similar solution using a control table setup for the files to log details of file accessed, steps in progress etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Reshedule SSIS Package & get back data on Failure