Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Converting DTS to Stored Procedures
Add to briefcase

Converting DTS to Stored Procedures Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
shivashankara9
Posted Tuesday, August 14, 2012 6:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 20, 2012 7:34 AM
Points: 33, Visits: 93
Hi,

I have DTS packages and i need to convert those DTS packages to Stored Procedures in SQL Server 2008 R2.

Some one please help me...how to do this process.
Post #1345094
SpringTownDBA
Posted Tuesday, August 14, 2012 9:11 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, June 06, 2013 10:38 AM
Points: 316, Visits: 1,488
1. Document current functionality of existing dts packages.
2. Write stored procedures to duplicate functionality.

Of course, it may be easier to recreate the dts packages as ssis packages, not stored procedures.
Post #1345115
Fernando Jacinto Alvarez
Posted Tuesday, September 25, 2012 12:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 7:20 AM
Points: 3, Visits: 40
You can use a tirad party tool like dos exchange from www.pragmaticworks.com
Post #1363817
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.