Wednesday, January 11, 2012

DTS not support in SQL Server 2008 R2

Limited SQL Server 2000 DTS Functionality on 64-bit Operating Systems
SQL Server 2008 does not include support for DTS in the following circumstances:
  • 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.
  • There is also no 32-bit design-time or run-time support for DTS packages on Itanium-based operating systems. Therefore, you cannot create, view, modify, or run DTS packages on Itanium-based operating systems.
Supported SQL Server 2000 DTS Functionality
SQL Server 2008 includes support for the following DTS features:
  • The DTS runtime, the object model that it exposes, and the dtsrun.exe command prompt utility.
  • The Execute DTS 2000 Package task, for executing DTS packages within Integration Services packages.
  • The ActiveX Script task, for backward compatibility only.
  • The DTS Package Migration Wizard, for migrating DTS packages to the Integration Services package format.
  • The Upgrade Advisor rules for DTS packages, for identifying potential issues that may be encountered when migrating packages.
more details on


mlee3680 said...

Great post. Here’s an online database apps company which provides free instructor-led training sessions

mlee3680 said...
This comment has been removed by the author.
christi parks said...

Are there some advantages of one language C and Java over the other? Which one is optimal? Which one is more "future proof"? Would it be optimal to know both? If so, which order? I am a little confused on the subject. Just got across this course, will it be helpful also. A little enlightenment could help. Thanks