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.SqlServer.Management.SqlManagerUI.DTSJob SubSystemDefinition.Microsoft.SqlServer.Management .SqlManagerUI.IJobStepPropertiesControl.Load(JobSt epData
data)
at
Microsoft.SqlServer.Management.SqlManagerUI.JobSte pProperties.UpdateJobStep()
at
Microsoft.SqlServer.Management.SqlManagerUI.JobSte pProperties.typeList_SelectedIndexChanged(Object
sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChang ed(EventArgs
e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Mes sage& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at
System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at
System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)

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 (AT) gmail (DOT) com> wrote