Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Opening/Editing DTS in SQL 2008 Expand / Collapse
Author
Message
Posted Saturday, October 6, 2012 7:08 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 22, 2014 8:54 AM
Points: 393, Visits: 973
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
Posted Monday, October 8, 2012 1:08 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:09 AM
Points: 870, Visits: 2,385
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 »

Add to briefcase

Permissions Expand / Collapse