May 9, 2006 at 9:02 am
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
May 11, 2006 at 3:44 pm
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
May 12, 2006 at 7:38 am
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
May 15, 2006 at 8:53 am
This is a question about Agent, not SSIS. http://www.sqlservercentral.com/forums/messages.aspx?forumid=110
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
May 15, 2006 at 10:02 am
Sorry.
Will re-post there. thanks
Skål - jh
November 14, 2007 at 1:30 pm
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\
December 13, 2007 at 9:25 am
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!
April 18, 2008 at 1:42 pm
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.
October 3, 2008 at 10:02 am
I tried to change environmental variables and reopen the managment studio,,,it worked. Thank you all.
January 12, 2009 at 1:18 pm
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
September 3, 2009 at 7:02 am
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
May 17, 2010 at 9:06 pm
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