How to install DTS Support in SQL Server 2008

Trying to use DTS letters on SQL Server 2008? A cryptic mistake about DTS Support? The files recommended my Microsoft, but still had issues? A few extra steps that you must take previous to getting DTS packages on SQL 2008 install.

Instructions

1. Step 1

The backwards compatibility tool SQLServer2005_BC.msi. Even although file says 2005, the file will work for SQL Server 2008.

2. Step 2

The DTS Runtime holds up SQLServer2005_DTS.msi. Even although the file says 2005, the file will work for SQL Server 2008.

Step 3

The DTS editor to work; need to copy a earlier version of SQL Server into the SQL Server 2008 folder. Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %Program Files%\Microsoft SQL Server\80\Tools\Binn folder to the %Program Files%\Microsoft SQL Server\100\Tools\Binn\Vessel\Common7\IDE folder.

Step 4

The DTS editor to work, you to copy some RLL files a previous version of SQL Server into the SQL Server 2008 folder. Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %Program Files%\Microsoft SQL Server\80\Tools\Binn\Resources folder to the %Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resource s\%lang_id% folder.