question

marlonribunal avatar image
marlonribunal asked

Tips & Tricks On SQL Server 2000 DTS Migration To SQL Server 2008 SSIS

I know I could just google (or bing) this phrase and it will return millions of results, but I want to get this information first-hand from people who have actually done this at least once.

sql-server-2008ssisdts
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

AaronTC05 avatar image
AaronTC05 answered

I'd recommend a product called DTSXChange (http://pragmaticworks.com/products/business-intelligence/dtsxchange/) which I've used and works pretty well if you have a lot of packages to convert. There's still some manual work to be done, but in most cases the tool gets you 90+% done, with a few minor tweaks needed.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rajib Bahar avatar image
Rajib Bahar answered
  1. Convert DTS packages that are simple.
  2. Keep complicated DTS packages as is and download the additional tool for SQL server 2005 so that you can run it inside the SQL Server.
  3. If there is no time or deadline involved then take the time to re-create the packages. You might learn more about SSIS that way.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rajib Bahar avatar image
Rajib Bahar answered

is it possible to remove my last response without using the voting option?

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.