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 http://msdn.microsoft.com/en-us/library/bb500440.aspx

3 comments:

mlee3680 said...

Great post. Here’s an online database apps company which provides free instructor-led training sessions http://blog.caspio.com/services/put-caspios-training-to-work-for-you/

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 http://www.wiziq.com/course/1779-core-and-advance-java-concepts, will it be helpful also. A little enlightenment could help. Thanks