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

Migrating DTS Packages to SSIS Expand / Collapse
Author
Message
Posted Monday, October 8, 2007 7:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 21, 2010 6:10 AM
Points: 13, Visits: 62
Hi all,

Can any body tell me how to migrate SQL Server 2000 DTS packages to SSIS, i am in very much need of it... i have 5 packages in my sql server 2000 i need to migrate that to SQL Server 2005.. please help me out\

Rgrds
Sunil
Post #407985
Posted Monday, October 8, 2007 10:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:35 AM
Points: 33,102, Visits: 15,213
There's a DTS 2000 runtime for SQL Server 2005 so you can run them. Otherwise, rewrite them in SSIS.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #408089
Posted Monday, October 8, 2007 10:01 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 21, 2010 6:10 AM
Points: 13, Visits: 62
I successfully completed migration of DTS packages from sql server 2000 to sql server 2005. but afer migration i am not able to see dts packages.

Is there any step still pending to view this dts packages?
Post #408277
Posted Thursday, February 25, 2010 7:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, May 1, 2013 4:01 PM
Points: 57, Visits: 42
check on the 2005 console -> management - > legacy -> dts you should see them there
Post #872762
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse