September 27, 2011 at 1:51 am
Hi Folks,
I have a sql server 2000 instance.i migrated my databases and DTS packages to SQL server 2008 R2.
Am unable to open the DTS packages which i migrated from SQL SERVER 2000 to SQL SERVER 2008 R2.
i've installed SQL server 2000 DTS Designer components and SQL server 2005 Backward compatability Softwares which was suggested by Microsoft and then copied the .dll and .rll files suggested by microsoft and then changed the path in Environment Variables.
After doing all these things as well am getting the same error while opening DTS pkg. in SQL SERVER 2008 R2
error is :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.DtsObjectExploreUI).
Please Help me...
TIA...
September 27, 2011 at 6:17 am
1) Install \x86\Setup\x86\SQLServer2005_BC.msi from the installation (Select DTS 2000 RunTime and SQL-DMO).
2) Download and install
3) 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.
4) 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.
If you're using a language other than "US-English", copy the RLL files from your LCID.
Hope this helps
Gianluca
-- Gianluca Sartori
September 27, 2011 at 6:53 am
Thanks for your Reply..
Unfortunately after doing all these steps am unable to open the DTS Packages and the same is error is coming what i mentioned in my post..
December 9, 2011 at 9:11 am
Bump - I'm also having this issue.
Short background on what I'm trying to do: modify a DTS package originally from SQL Server 2000 in 2008 R2 64-bit (Windows Server 2008 R2 SP1).
Here's what I've done:
1. Stopped SQL Server service.
2. Installed SQLServer2005_BC_x64.msi (selecting 2000 DTS runtime and SQL-DMO)
3. Installed SQLServer2005_DTS.msi
4. Started SQL Service service.
5. Tried to open DTS package --> "SQL Server 2000 DTS Designer components are required to edit DTS packages..."
6. Stopped SQL Server service.
7. Copied .DLL and .RLL as recommended by Gianluca above.
8. Started SQL Server service.
9. Tried to open DTS package --> "SQL Server 2000 DTS Designer components are required to edit DTS packages..."
Any ideas?
_____________________________________________________________________
- Nate
December 9, 2011 at 10:16 am
You probably need to copy the files not to
C:\Program Files
But to:
C:\Program Files (x86)
CEWII
December 9, 2011 at 11:39 am
Yep, my bad Elliott.
However that was where I put them, I just forgot to note it in my steps taken.
_____________________________________________________________________
- Nate
December 9, 2011 at 11:43 am
Well shoot, last time I had to do this those steps fixed it for me..
Re-apply service pack? I know its reaching, but my toolbox for this empty..
CEWII
December 9, 2011 at 1:51 pm
You might have to change the environment variables.
Right click Computer / Properties / Advanced system settings / Environment variables
In the “path” system variable make sure:
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn
Comes before:
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn
This has worked for me in the past.
December 12, 2011 at 8:47 am
Thxs Jeremy but no dice.
Changed the "path" system variable, rebooted and am still getting the "SQL Server 2000 DTS Designer components are required to edit DTS packages..." message.
_____________________________________________________________________
- Nate
December 12, 2011 at 10:47 am
We choose to leave one SQL2000 instance to host DTS-packages until the project teams get budget to upgrade the packages to SSIS.
Main reason is to avoid troubles as you have.
We run these dts packages from SQL2005 sqlagent jobs which us a proxy account that is able to execute the dts packages saved in the SQL2000.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 12, 2011 at 12:16 pm
Unfortunately we're not only upgrading from 2000 to 2008 R2 but we're also migrating over to a new domain which doesn't trust (and I'm told will never trust) the existing one and vice versa. So if I can't get DTS working, short of setting up a new 2000 server in the new domain, I'm thinking my only option is to migrate these over to SSIS ASAP.
_____________________________________________________________________
- Nate
December 12, 2011 at 2:25 pm
I used a 3rd party free tool to import all the DTS packages from 2000 to 2005 (http://www.sqldts.com/242.aspx). It worked perfectly with just about 3 mouse clicks total. Not sure if it works from 2000 to 2008.
April 19, 2013 at 6:33 am
test
April 19, 2013 at 6:35 am
Able to open and migrated in sql2008 r2 - x694 thru designer 2000 but during first time when we open it gives SQLDMO.dll has not registered and when we click ok able to get thru.
Wants to make sure its something needs to conceren or fix
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply