• Dst File
• How To Open Dts File

Jan 13, 2009 Problem=====When we open a SQL2000 DTS package in SQL2008 SSMS/BIDS It fails with below error. Error: ——–SQL Server 2000 DTS Designer components are.

An error occurs if you try to open a DTS package from Leagcy - Data Transformation Services in SSMS of 2008. The message says, SQL Server 2000 DTS Designer Components are required to edit DTS packages. Install the special web download, 'SQL Server 2000 DTS Designer Components' to use this feature. Downloading the following software from Microsoft's download center and Installing fixes this issue in most of the cases.

Dst File

Microsoft SQL Server 2005 Backward compatibility 2. Cursos de personalidad victor gordoa. SQL Server 2000 DTS Designer Components However, in some cases it doesn't solve the problem and the error re-appears even after installing the above software. Reason for this: SQL Server uses the library ( sqlgui.dll) to open DTS package in GUI mode. This DLL comes with katmai (Located in 100 Toos Binn) also but this shouldn’t be used. The DLL that comes with SQL server 2000 (Located in in 80 Toos Binn) should be used.

SQL server looks for the path of this DLL in the order in which the paths are defined in PATH environment variable. So, we need to make sure 80 comes before 100.

Perform the following steps to fix the issue in such situation. Please note that this workaround should be used in Development environments only. Playing with the environment variable on Production systems might hamper some or the other application and hence avoid this in such cases.

Ideally DTS Packages should be upgraded to SSIS packages as we move from sql 2000 to sql 2005/sql 2008. And one of the good articles which provides information on how to upgrade DTS packages to SSIS package is written by Jason Howell Some one said that the issue with path:- or Are you migrate or edit dts which is older version? You have to installed this:- or The reason are:-. 'You might need the 2000 runtime if you run this as a DTS package as well. I haven't worked with this in 2008, so I'm not sure, but 2005 had a runtime component as well.' . 'However, if all instances of the SQL Server 2000 relational engine are removed or upgraded to SQL Server 2008 R2, the ability to develop DTS packages will no longer exist.

How To Open Dts File

The SQL Server 2008 R2 Setup application will install an updated DTS runtime and command-line tools, but no DTS design environment will be available. In this case, you can install the DTS Designer Components via a Web download as part of the Feature Pack for Microsoft SQL Server 2005 - December 2008. For more DTS-related upgrade information, see Considerations for Upgrading Data Transformation Services in SQL Server 2008 R2 Books Online.