SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Reshedule SSIS Package & get back data on Failure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bhushan_juare
Starting Member

45 Posts

Posted - 09/27/2012 :  06:15:44  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 09/27/2012 :  07:10:23  Show Profile  Reply with Quote
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.aspx

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

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 09/27/2012 :  10:30:59  Show Profile  Reply with Quote
are you using some type of control table to log details of fetched files?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

bhushan_juare
Starting Member

45 Posts

Posted - 09/28/2012 :  01:40:35  Show Profile  Reply with Quote
Stored procudure got excuted on a Server to collect data then SQL Job run to get all data in one file..
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 09/28/2012 :  10:37:00  Show Profile  Reply with Quote
we implemented similar solution using a control table setup for the files to log details of file accessed, steps in progress etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000