May 19, 2009 at 4:47 am
Hi ALL
I have migrate my SQL from 2000 (Win 2003 platform) to SQL 2008 (Win Server 08 Itanium)
There's a package in Data Transformation Service that i need to migrate as well
Below are the steps that i'm using :
I have installed this package in my SQL 2008 : Microsoft SQL Server 2005 Backward Compatibility Components
Then i go to SQL Server Management Studio, Management, Legacy and DTS.
Then i import all the package that i save from SQL 2000
When i try to OPEN, i receive this following error :
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)
Then i download the "SQL Server 2000 DTS Designer Components"
Then when i try to open the package again, the same error i got state that i need to install "SQL Server 2000 DTS Designer Components"
My Concern are :
1. Based on above explaination, is that a correct way to migrate the package from sql 2000 to sql 2008??
Please HELP MEEEEEEEEEEEEEEEEEEEEEEEE:w00t:
May 19, 2009 at 7:08 am
I think Itanium is the problem so you need to either get x86 or x64 do the migration and then import into Itanium. There were problems with using Oracle but if the package was developed in x86 and imported into Oracle it works so try using x86 or x64.
Kind regards,
Gift Peddie
July 27, 2009 at 7:50 am
Did you ever get this working as i have exactly the same problem on a x86 based server. I've also tried other tips like copying 6 DLL files into my \100\binn and putting the SQl2008 paths before SQL2000 in the PATH env....stillno luck!!!
July 29, 2009 at 5:40 pm
My notes on this when I had the same issue are:
To get DTS working in SQL 2008, install the DTS backward compatibility tools, SQLServer2005_BC.msi (found on the install media)
To be able to edit DTS’s on the server install the DTS design tools, SQLServer2005_DTS.msi then copy
%Program Files%\Microsoft SQL Server\80\Tools\Binn\semsfc.dll
%Program Files%\Microsoft SQL Server\80\Tools\Binn\sqlgui.dll
%Program Files%\Microsoft SQL Server\80\Tools\Binn\sqlsvc.dll
%Program Files%\Microsoft SQL Server\80\Tools\Binn\Resources\%lang_id%\semsfc.rll
%Program Files%\Microsoft SQL Server\80\Tools\Binn\Resources\%lang_id%\sqlgui.rll
%Program Files%\Microsoft SQL Server\80\Tools\Binn\Resources\%lang_id%\sqlsvc.rll
To the following destination respectively
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\semsfc.dll
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\sqlgui.dll
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\sqlsvc.dll
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id%\semsfc.rll
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id%\sqlgui.rll
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id%\sqlsvc.rll
I think one .msi file was on the install media and the other one I downloaded.
July 30, 2009 at 2:47 am
Thanks for that Grasshopper. That was exactly what I did but still no joy!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply