Error creating ssis package job step
********************EDIT*******************
* The issue resolved itself with a restart.
* Sorry if I wasted anyone's time.
******************************************
Hi All,
I wonder if anyone has seen this before.
I'm on a fresh installation of Sql Server 2005 CTP (32 bit enterprise, running on win server 2003), attempting to set up a job to run an SSIS package.
I create a new job, create a new step, select "SQL Server Integration Services Package" under Type, and immediately get the following error:
===================================
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI)
Program Location:
at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.Microsoft.SqlServer.Management.SqlManagerUI.IJobStepPropertiesControl.Load(JobStepData data)
at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.typeList_SelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
==================================
Is there any configuration work I need to do before I can create this type of step?
The server has not had Sql Server on it before, but it does have visual studio 2003 (pre-dating sql server 2005).
Any ideas?
Thanks,
Matt
