Migrating DTS Packages from SQL 2000 to 2008

Question

Migrating DTS Packages from SQL 2000 to 2008

vamshi.sql

SSCommitted

Points: 1770
More actions
May 27, 2010 at 2:16 pm

#233138

I am looking to migrate the SQL 2000 applications to SQL Server 2008
and the OS will be Windows 2003 Server.
the server where we run a lot of DTS's. I understand that SQL 2008
requires some add-ons to be downloaded and installed to make DTS's
work.
Can you please let me know which type of add-ons I need to download it? and where can I download that?
Thanks in advance,
Vamsi.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

MarlonRibunal Ten Centuries Points: 1332 More actions · Answer 1

I suggest that you rebuild all the packages from the ground up. Trust me on this one. I am currently migrating SQL Server 2000 DTS packages to SQL Server 2008 Packages.

Watch our for data transformation in the old packages. I have posted some on my experiences in the migraion in my blog:

http://dbalink.wordpress.com/2010/03/25/ssis-2008-variables-101/

http://dbalink.wordpress.com/2010/01/27/dts-to-ssis-migration-unable-to-cast-com-object-issue/

http://dbalink.wordpress.com/2009/12/23/ssis-2008-flat-file-source-issue/

http://dbalink.wordpress.com/2009/10/16/ssis-2008-quick-notes/

Have fun!

SQL Server Database Administrator

farside41 SSCrazy Points: 2083 More actions · Answer 2

vamshi.sql (5/27/2010)
I am looking to migrate the SQL 2000 applications to SQL Server 2008
and the OS will be Windows 2003 Server.
the server where we run a lot of DTS's. I understand that SQL 2008
requires some add-ons to be downloaded and installed to make DTS's
work.
Can you please let me know which type of add-ons I need to download it? and where can I download that?
Thanks in advance,
Vamsi.

You need the "Microsoft SQL Server 2005 Backward Compatibility Components" Feature Pack, you can find it here. I can't tell you which package to download because I don't know what your architecture is.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1

MarlonRibunal Ten Centuries Points: 1332 More actions · Answer 3

You need the "Microsoft SQL Server 2005 Backward Compatibility Components" Feature Pack, you can find it here. I can't tell you which package to download because I don't know what your architecture is.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1%5B/quote%5D

Don't just install that component in the same machine you have the SQL Server 2000 Enterprise Manager. If you do that you will have this problem when you open the Enterprise Manager:

That said, let me reiterate my suggestion: rebuild the old DTS packages into SQL 2008 as new packages.

😉

SQL Server Database Administrator

vamshi.sql SSCommitted Points: 1770 More actions · Answer 4

vamshi.sql

SSCommitted

Points: 1770

May 27, 2010 at 5:19 pm

#1173656

Thanks allot for your reply.