2000 DTS packages

[Rena]

Hi,
Just wanted to know how we can convert MS SQL 2000 DTS packages to MS SQL
2005
Please send step by step instructions

[Todd C]

You will need an installation of SQL 2005 (Developer, Standard, or
Enterprise) in order to do this. SQL Express will not work.

In your SQL 2005 (or 2008) Management Studio, look for the Legacy node, and
under that, Data Transformation Services. Right CLick on any of the DTS
packages and select Migrate. Follow the prompts in the wizard.

Be aware that *some* DTS stuff may not migrate well to SSIS and you may end
up with either an SSIS package that doesn't work right if it works at all, or
an SSIS package that simple calls a DTS package to run.

As a long-term solution, you should see about re-creating your DTS packages
using SSIS standard tasks and transforms. SSIS has a lot more functionality
and flexibility available.

HTH
--
Todd C
MCTS SQL Server 2005

Post by Rena
Hi,
Just wanted to know how we can convert MS SQL 2000 DTS packages to MS SQL
2005
Please send step by step instructions

[Russell Fields]

Rena,

Microsoft has provided some wizards to help migrate DTS to SSIS.
There are resources on the web, for example:
http://technet.microsoft.com/en-us/library/cc966389.aspx

http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration/

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/upgradingsqlserver2000dtspackagestossis/2201/

As you read these, you will see that you will probably need to do some hand
work as well to finish the migrations.

RLF

Post by Rena
Hi,
Just wanted to know how we can convert MS SQL 2000 DTS packages to MS SQL
2005
Please send step by step instructions

[Paul Shapiro]

You can run DTS packages in SQL 2005 if that's what you want to do. You can
download the free Backwards Compatibility components from MS website.

Post by Rena
Hi,
Just wanted to know how we can convert MS SQL 2000 DTS packages to MS SQL
2005
Please send step by step instructions

[tbradshaw via SQLMonster.com]

Rena,

One approach that wasn't mentioned here, is there is a product called "DTS
xChange" that will help you with conversions from DTS to SSIS.
http://www.pragmaticworks.com

It's pricey, but depending on the amount of packages to convert, it's cheap
compared to the amount of hours a person would spend converting each package
by hand.

Just a thought.

Regards,
Tom Bradshaw

Thomas Bradshaw
Data Transformation Services
MyWebGrocer Inc