August 16, 2012 at 8:31 am
I have been handed over DTS packages in SQL 2008. Now, If i need to edit them, its not opening. Its a 64 bit machine.
I have installed
1. SQLServer2005_BC.msi, it does not install
2. SQLServer2005_DTS.msi, installed
3. SQLServer2005_BC_x64.msi
made below changes
Copy SEMSFC.DLL, SQLGUI.DLL, SQLSVC.DLL
From C:\Program Files\Microsoft SQL Server\80\Tools\Binn
To C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
Change the path according to your SQL Server setup.
Copy SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL
From C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033
To C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033
Change the path according to your SQL Server setup.
Environment Path variable has \80\Tools\Binn\ before \100\Tools\Binn\
Still i get error when opening DTS.
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. (Microsoft.SqlServer.DtsObjectExplorerUI)
Is there any way to open DTS in SQL 2008 through SSMS?
August 16, 2012 at 8:41 am
Is there any way to open DTS in SQL 2008 through SSMS?
Short answer, no.
You want to open this with Visual Studio or Business Intelligence Development Studio (BIDS). You can use VS or BIDS to convert a 2000 DTS package to SSIS (SQL Server Integration Services).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply