Post reply

DTS package error with SQL Server 2008 R2

  • July 21, 2011 at 12:23 pm

    #244694

    Tried everything, still getting the same 'SQL Server 200 DTS Components...' error message with 2008 SSMS. I have both 2005 & 2008 SSMS installed in my WIN7 Prof., BC & DTS.msi installed, edited the path, restarted SQL services... 2005 SSMS is working, but not 2008 🙁

    need some helps, thanks in advance.

    here's my path:

    %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\10.0\DLLShared\;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\WINDOWS\system32\WindowsPowerShell\v1.0; C:\Program Files\TortoiseSVN\bin

  • July 21, 2011 at 12:56 pm

    #1356679

    What specific error are you getting?

    I don't know if this applies without knowing the error but try this link:

    http://blogs.msdn.com/b/ramoji/archive/2008/10/16/how-to-open-dts-packages-in-sql-server-2008.aspx

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 21, 2011 at 1:15 pm

    #1356686

    it's the same message:

    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)

    already did all these in that page, didn't help.

  • July 21, 2011 at 1:27 pm

    #1356693

    chukostar (7/21/2011)

    Tried everything, still getting the same 'SQL Server 200 DTS Components...' error message with 2008 SSMS. I have both 2005 & 2008 SSMS installed in my WIN7 Prof., BC & DTS.msi installed, edited the path, restarted SQL services... 2005 SSMS is working, but not 2008 🙁

    need some helps, thanks in advance.

    here's my path:

    %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\10.0\DLLShared\;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\WINDOWS\system32\WindowsPowerShell\v1.0; C:\Program Files\TortoiseSVN\bin

    What error message?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 21, 2011 at 1:28 pm

    #1356695

    chukostar (7/21/2011)

    it's the same message:

    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)

    already did all these in that page, didn't help.

    I missed your BC abbreviation and perhaps I'm going blind and I missed your error message as well. 🙂

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 21, 2011 at 1:36 pm

    #1356701

    np... just so frustrated, DTS was working w/ 2008 before my system crashed yesterday. That's why I have to reinstall and redo everything... I remember I had the same issues the first time and did the same things to fix it...

  • July 21, 2011 at 1:39 pm

    #1356702

    chukostar (7/21/2011)

    np... just so frustrated, DTS was working w/ 2008 before my system crashed yesterday. That's why I have to reinstall and redo everything... I remember I had the same issues the first time and did the same things to fix it...

    OK, I understand your frustration.

    I don't believe that you mentioned that DTS worked before your system crashed, that is good to know.

    Can you provide the error that you are getting?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 21, 2011 at 1:48 pm

    #1356712

    sorry, I think I put it in a wrong way... shouldn't call it error message.

    In 2008 SSMS, I go under 'Management', then 'Legacy', expand 'Data Transformation Services', all DTS packages would list out, right click open anyone of them, DTS 2000 Package Designer would open with a smaller window 'Object Explorer' and message:

    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)

    ** did the same thing with 2005 SSMS, and it works **

  • July 21, 2011 at 1:53 pm

    #1356715

    chukostar (7/21/2011)

    sorry, I think I put it in a wrong way... shouldn't call it error message.

    In 2008 SSMS, I go under 'Management', then 'Legacy', expand 'Data Transformation Services', all DTS packages would list out, right click open anyone of them, DTS 2000 Package Designer would open with a smaller window 'Object Explorer' and message:

    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)

    ** did the same thing with 2005 SSMS, and it works **

    ok, sounds like it's telling you that you do not have the DTS Designer and BC installed on your SQL Server 2008 Instance and you have it on the SQL Server 2005 instance.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 21, 2011 at 1:58 pm

    #1356716

    hmm... I have both 2005 & 2008 SSMS installed in my Win7 PC, also installed both BC & DTS designer. How can you tell which instance it applied to?

  • July 21, 2011 at 2:05 pm

    #1356723

    chukostar (7/21/2011)

    hmm... I have both 2005 & 2008 SSMS installed in my Win7 PC, also installed both BC & DTS designer. How can you tell which instance it applied to?

    You are not configured for the SQL Server 2008 instance.:-D

    Please refer to the link that I provided you in my inital reply and give it a shot.

    http://blogs.msdn.com/b/ramoji/archive/2008/10/16/how-to-open-dts-packages-in-sql-server-2008.aspx

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 22, 2011 at 7:08 am

    #1357027

    Did you solve the problem?



    My blog

  • July 22, 2011 at 8:05 am

    #1357061

    it's fixed... believe it or not, I got the another 2005 DTS msi file from Microsoft, installed it, and everything started to work, on both 2005 & 2008 SSMS, same filename, but I guess it's a different version, thanks to MS, I wasted almost whole day trying to figure that out 🙁

    thanks for all your help,

  • July 22, 2011 at 5:16 pm

    #1357364

    Thanks for sharing!



    My blog

  • July 22, 2011 at 5:20 pm

    #1357366

    Thanks, I tried to point you in the right direction.

    Based on your comments I did not not provide any suggestions that led to you resolving this issue?

    Nice.:-D

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply