question

pvsrinivasrao avatar image
pvsrinivasrao asked

Is there a way to view SQL Server 2000 DTS files like on a IDE

Hi Friends, I have to open and see DTS packages on desinger to figure out an migration error...but to do this SSMS 2008 with DTS Desginer components is not working its throwing some unhandled error. So just thinking if we can open it in some kind of IDE so that I can figuegure out error. OS i am using is Windows 7 Thanks
sql-server-2008sqlsql-serversql-server-2000dts
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
WilliamD avatar image
WilliamD answered
You could install the old SQL Server 2000 client tools, which includes the DTS Designer. I would then suggest to look at migrating the DTS packages to SSIS.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Pavel Pawlowski avatar image Pavel Pawlowski commented ·
+1 here is the MSDN link [How to: Install Support for Data Transformation Services Packages][1] [1]: http://msdn.microsoft.com/en-us/library/ms143755.aspx
1 Like 1 ·

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.