SQL 2008 and DTS
SQL Server 2008 provides optional 32-bit management, run-time, and design-time support for packages that were created by using the DTS tools and object model. However not all DTS functionality is supported in all circumstances.
Following DTS functionality is supported in SQL Server 2008 64 Bits:
• 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.
Following DTS functionality is not supported in SQL 2008 64 Bits:
• 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. To run DTS packages in 32-bit mode, you have to install and use the 32-bit version of the dtexec utility (dtexec.exe). To install the 32-bit version of the dtexec utility, select Client Tools or Business Intelligence Development Studio during setup.
• 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.
Also the Execute DTS 2000 Package task, the ActiveX Script task, and the DTS Package Migration Wizard are installed when you select Integration Services for installation. However, these components are not fully functional without the manual installation of additional, optional components that are not available during Setup.
So if you are facing issues with DTS in SQL 2008, I recommend you to spend some time at http://msdn.microsoft.com/en-us/library/bb500440.aspx. This is surely a great resource to start with.
Following DTS functionality is supported in SQL Server 2008 64 Bits:
• 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.
Following DTS functionality is not supported in SQL 2008 64 Bits:
• 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. To run DTS packages in 32-bit mode, you have to install and use the 32-bit version of the dtexec utility (dtexec.exe). To install the 32-bit version of the dtexec utility, select Client Tools or Business Intelligence Development Studio during setup.
• 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.
Also the Execute DTS 2000 Package task, the ActiveX Script task, and the DTS Package Migration Wizard are installed when you select Integration Services for installation. However, these components are not fully functional without the manual installation of additional, optional components that are not available during Setup.
So if you are facing issues with DTS in SQL 2008, I recommend you to spend some time at http://msdn.microsoft.com/en-us/library/bb500440.aspx. This is surely a great resource to start with.
Comments