Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Failed to launch Execute Package Utility

제안된 답변 Failed to launch Execute Package Utility

  • Tuesday, December 04, 2012 11:54 AM
     
     
    Sign In to Vote
    0

    Hi,

    I am unable to open "Execute Package Utility". It is throwing below error.

    The program has failed to Load the library "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dts.dll".

    My OS is 64 bit and below are the orders of path in environment variable

    C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;
    C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;
    C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;
    C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;

    Can anyone let me know how to fix this issue?

    Thanks in advance.

    --

    Harry

     

All Replies

  • Tuesday, December 04, 2012 12:07 PM
     
     
    Sign In to Vote
    0
    Why .dll? To use DTEXEC 2005, specify full path, like "c:\program files\Microsoft Sql Server\90\dts\binn\dtexec.exe" /f Package.dtsx

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

     
  • Tuesday, December 04, 2012 12:23 PM
     
     
    Sign In to Vote
    0

    Uri,

    It is throwing error while i try to open from Start menu.

    Additionally it is not allowing me to execute package using .net application.

    --

    Harry

    • Edited by HirenK Tuesday, December 04, 2012 12:25 PM
    •  
     
  • Tuesday, December 04, 2012 12:32 PM
     
     
    Sign In to Vote
    0

    I can think about two possibilities 

    1) Login does not have permission to the specified path

    2) Client tools was installed properly ..

    BTW if you try to execute dtexec.exe what error are  you getting?

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

     
  • Tuesday, December 04, 2012 12:34 PM
     
     
    Sign In to Vote
    0

    Could you please verify if you see below DLL's in the specified path?

    C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtsmsg100.dll
    C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dts.dll

     
  • Tuesday, December 04, 2012 12:45 PM
     
     
    Sign In to Vote
    0

    Yes, Deep

    Both dlls are there in same directory

    Hiren Kapadia

     
  • Tuesday, December 04, 2012 1:40 PM
     
     
    Sign In to Vote
    0
    Hirenk, May be there is some problem with the shared components. If this is not a production server then you may try to repair the shared components
     
  • Wednesday, December 05, 2012 6:19 AM
     
     
    Sign In to Vote
    0

    Hi HirenK,

    Please run command prompt as an administrator, and run dtexecui command with command prompt window. You can also try to open Execute Package Utility in SQL Server Management Studio. For more detail information, please refer to the following link:

    Execute Package Utility (DtExecUI) UI Reference:
    http://msdn.microsoft.com/en-us/library/ms180378.aspx

    Allen Li
    TechNet Community Support

     
  • Wednesday, December 05, 2012 8:48 AM
     
     
    Sign In to Vote
    0

    Hi Allen,

    I tried it but didnt work.

    I think i need to change order of path in environment variable.

    Thanks,

    Hiren Kapadia

     
  • Thursday, December 06, 2012 6:52 AM
     
     
    Sign In to Vote
    0

    Hi Everyone,

    After changing orders of executable paths in environment variables, I am unable to execute packages.

    I tried to run package from SQL server management studio --> by connecting Integration service.

    It throw below error

    The program has failed to Load the library "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dts.dll"

    If I create SQL job for the same package, it won't throw any error.

    Can anyone help me to fix this issue?

    Thanks,

    Hiren Kapadia



    • Edited by HirenK Thursday, December 06, 2012 7:30 AM
    •  
     
  • Friday, December 07, 2012 8:47 AM
     
     Proposed
    Sign In to Vote
    0

    Hi, let’s execute the following commands one by one with Command Prompt to register the DLL files:

    c:\windows\system32\regsvr32 "c:\Program Files\Microsoft SQL Server\100\DTS\Binn\dts.dll"
    c:\windows\syswow64\regsvr32 "c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dts.dll"

    After finishing the above steps, let’s check the result again.

    Allen Li
    TechNet Community Support

    • Proposed As Answer by Allen Li - MSFT Monday, December 10, 2012 1:32 AM
    •  
     
  • Friday, December 07, 2012 6:08 PM
     
     
    Sign In to Vote
    0

    I am having the same issue. The regsvr32 didn't work. The error that HirenK is referring to happens any time dtexecui is run either through the command prompt, SSMS UI or just double clicking a dtsx package. No log event gets created so its difficult tracking this one down. I had an issue a couple days ago with a software installation corrupting my BIDS installation and so I did a repair on MSSQLSERVER and all seemed fine. I am running SQL 2008R2 SE on Server 2008R2.

    One thing that is saving my bacon right now like HirenK noted is that the packages can be run as jobs if that helps track this down.

    Thanks,

    Vince Nichols

    • Proposed As Answer by Vince Nichols Friday, December 07, 2012 7:30 PM
    • Unproposed As Answer by Vince Nichols Friday, December 07, 2012 7:30 PM
    •  
     
  • Friday, December 07, 2012 7:32 PM
     
     Proposed
    Sign In to Vote
    0

    Sorry, I should have looked a little longer. I found my solution in this thread:

    http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/a7089429-c749-41e8-83e0-c434991d9115

    Hope it helps.

    Vince Nichols

    • Proposed As Answer by Vince Nichols Friday, December 07, 2012 7:33 PM
    •  
     
  • Monday, December 10, 2012 9:21 AM
     
     
    Sign In to Vote
    0
    Allen, it didnt work.

    Hiren Kapadia

     
  • Monday, December 10, 2012 9:25 AM
     
     
    Sign In to Vote
    0

    Hi Vince,

    Thanks for your answers. I have gone through this earlier and it wasn't helpful. I have mentioned about above link in my separate forum 

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/13408a1a-4e13-4fc5-a253-9ae267eadff1#0640a1da-f88a-4c59-93dd-3a58bcc41032

    I will try to repair and then see if its fixed or not.

    Thanks,

    Hiren Kapadia


    • Edited by HirenK Monday, December 10, 2012 9:54 AM
    •  
     
  • Wednesday, December 12, 2012 4:08 AM
     
     
    Sign In to Vote
    0

    Hi, please check whether "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dts.dll" exists, if not, let’ remove the following paths from in environment variable and check the result again:

    C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;
    C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;

    Otherwise, please remove the following paths from in environment variable and check the result again:

    C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;
    C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;

     

    Allen Li
    TechNet Community Support

     
  • Wednesday, December 12, 2012 11:58 AM
     
     
    Sign In to Vote
    0
    Yes, this .dll files is available there.

    Hiren Kapadia

     
  • Friday, December 14, 2012 9:27 AM
     
     
    Sign In to Vote
    0

    Hi, please remove the following paths from in environment variable and check the result again:

    C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;
    C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;

    Allen Li
    TechNet Community Support