question

Testadoora avatar image
Testadoora asked

Run a 32 bit SQL2000 DTS package in SQL2008 R2?

How do I run a 32 bit sql server 2000 dts package in sql server 2008 R2?
sql-server-2008-r2sql-server-2000dts
10 |1200

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

Tim avatar image
Tim answered
You will have to do so from command line. ”C:\Program Files (x86)\\Microsoft SQL Server\\100\\DTS\\Binn\\dtexec.exe”
10 |1200

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

Shawn_Melton avatar image
Shawn_Melton answered
If you pasted that exact question in Google it will give you your answer: [first link in the results][1]. You will actually need to install the DTS run time on your SQL Server 2008 R2 server if you have not already. There are other limitations that the link will provide. [1]: http://technet.microsoft.com/en-us/library/ms143755%28v=sql.105%29.aspx
10 |1200

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.