Opening/Editing DTS in SQL 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Opening/Editing DTS in SQL 2008

Opening/Editing DTS in SQL 2008

Rate Topic

Display Mode

Topic Options

Author

Message

balasach82

Posted Saturday, October 06, 2012 7:08 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 307, Visits: 743

In Windows 2008 64bit server, even after installing Backward comp components, I could not open DTS in SQL 2008.

I have tried most of the options specified in msdn and other links which mentions copying some dll's. Nothing is working. Unless there should be some way to overcome this, Microsoft would not have provided DTS support in sql 2008. Any idea to resolve this?

Post #1369490

Jason-299789

Posted Monday, October 08, 2012 1:08 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:30 AM
Points: 803, Visits: 2,124

While DTS 2000 is technically supported in SQL2008 its only available on the x86 (32bit) version.

See

http://msdn.microsoft.com/en-us/library/bb500440(v=sql.105).aspx

Especially

There is no 64-bit design-time or run-time support for DTS packages. On a 64-bit computer, DTS packages, and Integration Services packages that run DTS packages, can run only in 32-bit mode. For more information, see How to: Install Support for Data Transformation Services Packages

Are you running DTS on a 2008 box or just want to view the pacakges that are on a 2000 box, if its the latter then you ight be better installing a VM with SQL 2000 management tools and viewing them that way.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Post #1369638

« Prev Topic | Next Topic »

Permissions