Cannot add SSIS package in Job

  • When I try and add a job step to run a SSIS package I get the error:

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI)

    ------------------------------

    I have Developer edition installed locally.  Any way to install just that module?

    thanks everybody

    Skål - jh

  • I am getting the exact same error that you are when I add a new step to a job and select "SQL Server Integration Services Package" it give me the The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI). I was able to add a package to another job a couple of weeks ago and now it gives me this error. Here is the pertinent os, sql server information.

    Microsoft SQL Server Standard Edition

    Microsoft SQL Server Management Studio9.00.1399.00

    Microsoft Analysis Services Client Tools2005.090.1399.00

    Microsoft Data Access Components (MDAC)2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

    Microsoft MSXML2.6 3.0 4.0 5.0 6.0

    Microsoft Internet Explorer6.0.2900.2180

    Microsoft .NET Framework2.0.50727.42

    Operating System5.1.2600

    Thanks.

    Luther

  • Could it be a 2005 sp1 bug!?!

    My developer edition is running on XPPro. If I connect to another machine that does not have SP1 from my local management studio I still *cannot* add a SSIS step and get that, but if I term serv into the machine and use it's studio I *can*.

    Anyone got the roll back notes for SP1 handy? Damn.

    Skål - jh

  • This is a question about Agent, not SSIS. http://www.sqlservercentral.com/forums/messages.aspx?forumid=110

    -Jamie

     

  • Sorry.

    Will re-post there. thanks

    Skål - jh

  • Hi team,

    I have the same problem and getting execption while adding the job for SSIS package and resolved this issue by adding the environment variables.

    Please add the following environment variables and close the studio manager and re-open and try to schedule the job.

    C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\

  • It looks to me like you are using the Management Studio on an X64 platform of Windows. The above environment variables should be specifically for users in 64-bit environments.

    I also have a user encountering the same issue, but I am having him uninstall the Standard Edition client tools with Service Pack 2 and installing the Enterprise Edition tools on his x86 workstation. After reinstalling, he will also install Service Pack 2. I will let you know if he still has the problem afterwards!

  • Hi everyone,

    I got exactly same error when I tried to edit my SSIS package.

    Can somebody give a help?

    The package worked fine two days before as scheduled job, and since we changed the objects owner to other, then it run failed now.

  • I tried to change environmental variables and reopen the managment studio,,,it worked. Thank you all.

  • After SqlServer2005 Enterprise with SP2 and Cumulative 7 installation, I also received same error. But after restarting the server I am good to go now. I am no longer getting the error and I am able to edit the job with SSIS maintenance plan.

    Bhavani

  • I have the same problem at the moment, but I don't know which environment variable I'm supposed to add it to?

    Cheers

    Launa

  • I have the same problem and I do this

    1. My computer- > right click

    2. Advance -> environment Variables

    3. System variables- > path

    ** Please change with careful **

    let say you have this in path

    C:\WINDOWS\system32;C:\WINDOWS

    append this line at behind

    C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Microsoft SQL Server\90\DTS\Binn

    c:\program files\Microsoft SQL Server\90\DTS\Binn\ is the location of DTS\Binn in your server

    please replace with the correct path

Viewing 12 posts - 1 through 11 (of 11 total)

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