Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Converting DTS to Stored Procedures Expand / Collapse
Author
Message
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
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: Tuesday, April 1, 2014 3:26 PM
Points: 316, Visits: 1,497
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
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: Thursday, November 13, 2014 4:51 PM
Points: 3, Visits: 49
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