Step SQL Server Integration Services Package Error in SQL ServerAgent

[jasonnance77@gmail.com]

I have built a SSIS package which runs fine in BIDS. I went into Sql
Server Management Studio and created a new job and job step. When I
select the SQL Server Integration Services Package, I get the below
error. There are no options on selecting a SSIS package.

I searched this error for about 5 hours yesterday and the only
solution I could find was a user who rebooted their server which fixed
this problem. I did restart the server, which did not fix the
problem.

Can anyone help provide more information on this problem and the
solution to it? Thank you, Jason.

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

------------------------------
Program Location:

at
Microsoft.SqlSe rver.Management .SqlManagerUI.D TSJobSubSystemD efinition.Micro soft.SqlServer. Management.SqlM anagerUI.IJobSt epPropertiesCon trol.Load(JobSt epData
data)
at
Microsoft.SqlSe rver.Management .SqlManagerUI.J obStepPropertie s.UpdateJobStep ()
at
Microsoft.SqlSe rver.Management .SqlManagerUI.J obStepPropertie s.typeList_Sele ctedIndexChange d(Object
sender, EventArgs e)
at System.Windows. Forms.ComboBox. OnSelectedIndex Changed(EventAr gs
e)
at System.Windows. Forms.ComboBox. WmReflectComman d(Message& m)
at System.Windows. Forms.ComboBox. WndProc(Message & m)
at
System.Windows. Forms.Control.C ontrolNativeWin dow.OnMessage(M essage& m)
at
System.Windows. Forms.Control.C ontrolNativeWin dow.WndProc(Mes sage& m)
at System.Windows. Forms.NativeWin dow.Callback(In tPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)

[Dan Guzman]

Re: Step SQL Server Integration Services Package Error in SQL Server Agent

It seems there is an issue with your SSMS installation. Try reinstalling
the SQL Server client tools (and service pack 2) to see if that fixes the
problem. You might be able to work around the issue using a CMDEXEC step
instead that executes DTEXEC.EXE instead an SSIS package step.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<jasonnance77@g mail.comwrote in message
news:1ff8127e-ba2d-4b8e-9c7c-41d3b7c48ef5@i2 9g2000prf.googl egroups.com...

>I have built a SSIS package which runs fine in BIDS. I went into Sql
Server Management Studio and created a new job and job step. When I
select the SQL Server Integration Services Package, I get the below
error. There are no options on selecting a SSIS package.
>
I searched this error for about 5 hours yesterday and the only
solution I could find was a user who rebooted their server which fixed
this problem. I did restart the server, which did not fix the
problem.
>
Can anyone help provide more information on this problem and the
solution to it? Thank you, Jason.
>
The specified module could not be found. (Exception from HRESULT:
0x8007007E) (SqlManagerUI)
>
------------------------------
Program Location:
>
at
Microsoft.SqlSe rver.Management .SqlManagerUI.D TSJobSubSystemD efinition.Micro soft.SqlServer. Management.SqlM anagerUI.IJobSt epPropertiesCon trol.Load(JobSt epData
data)
at
Microsoft.SqlSe rver.Management .SqlManagerUI.J obStepPropertie s.UpdateJobStep ()
at
Microsoft.SqlSe rver.Management .SqlManagerUI.J obStepPropertie s.typeList_Sele ctedIndexChange d(Object
sender, EventArgs e)
at System.Windows. Forms.ComboBox. OnSelectedIndex Changed(EventAr gs
e)
at System.Windows. Forms.ComboBox. WmReflectComman d(Message& m)
at System.Windows. Forms.ComboBox. WndProc(Message & m)
at
System.Windows. Forms.Control.C ontrolNativeWin dow.OnMessage(M essage& m)
at
System.Windows. Forms.Control.C ontrolNativeWin dow.WndProc(Mes sage& m)
at System.Windows. Forms.NativeWin dow.Callback(In tPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)
>