Regarding DTS in SQL Server 2005

[sendba]

Hi all

Please let me know how I can migrate my DTS package to SQL Server 2005.

And also please let me know how to use SSIS.

Thanks in advance

Sen

 

[mrdenny]

There is a wizzard which can be used. It would probably be better to rebuild them manually unless the DTS packages are fairly basic.

Um, that's a lot more complex than can be handled in a thread.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sendba]

MRDENNY

which Wizard i can use and can you let me know where to look for this wizard

 

[SQLBill]

Open up SQL Server 2005, expand the server utni you find Management, expand that until you see Legacy, expand that and find Data Transformation Services. Right click on that and you will find Import Package File. There is also a Migration Wizard there.

I really suggest you open the Books OnLine (documentation with SQL Server) and read up on it.

-SQLBill

Posting advice: FAQ481-4875

 

[Catadmin]

There are a lot of little caveats in upgrading DTS packages to SSIS, both using the Wizard and without using the Wizard. Since there are components which could possibly stub during the install process, I second Denny's recommendation in rebuilding the package from scratch instead of upgrading. We ran into a LOT of problems trying to upgrade and it actually took us less time to rebuild them than fix them after the upgrade.

BTW, SSIS has so much new functionality, that you could probably shorten your DTS packages if you rebuild them instead of upgrade them.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[sendba]

THANKS MRDENNY , SQLBILL AND CATADMIN