View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 02:46 PM
jasonnance77@gmail.com
 
Posts: n/a
Default Step SQL Server Integration Services Package Error in SQL ServerAgent

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)

Reply With Quote