[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


DTS on SQL2008

Posted on 2009-12-18
Medium Priority
Last Modified: 2012-05-08

I know it is better to move it to SSIS, but I have a few DTS that I need to use right away, is there a way?thx
Question by:mcrmg
  • 2
  • 2
LVL 26

Expert Comment

ID: 26084579
by installing the backward compatibility tools you may call the old dts packages from sql server 2008

and have a look at the link at msdn


Author Comment

ID: 26084647
I believ I have a 64bits box, when can I locate backward compatibility tools ?  thx
LVL 26

Accepted Solution

tigin44 earned 1000 total points
ID: 26084656
you can download it from microsoft site... and install it..

Author Comment

ID: 26084714
doesnot seem to find it....

if I open my sql2000 with this dts in it, if I change the servername, is there a way that I can run the dts on 2000 but the data is going to 2008, so 2000 serves as a "bridge|"?  thx

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question