Yesterday I created a SSIS package to migrate VFP table to SQL Server 64 bit. It worked well in BIDS. Now I decided to test creating it as a job. I created a deployment utility, then double clicked on the Manifest, created the package inside SQL Server. I then created a job. I used Windows authentication in all cases (as I'm running this locally). When I tried to run the job it failed with the information that connection 'Naomi' is invalid in the command line. When I tried to edit the job step, I got this error: =================================== Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Package..ctor() at Microsoft.DataTransformationServices.DTSExecUI.Controls.LoggingCtrl..ctor(IDTSExecViewManager treePanel) at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.InitializeControls() at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition..ctor(CDataContainer dataContainer, IMessageBoxProvider messageProvider) at Microsoft.SqlServer.Management.SqlManagerUI.JobStepSubSystems..ctor(CDataContainer dataContainer, JobStepData data, IMessageBoxProvider messageProvider) at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.get_SubSystems() at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeStepCombo() at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeData() at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.OnInitialization() at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SelectCurrentNode() at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.InitializeUI(ViewSwitcherTreeView treeView, ISqlControlCollection viewsHolder, Panel rightPane) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(ISqlControlCollection control, IServiceProvider provider) at Microsoft.SqlServer.Management.SqlManagerUI.JobSteps.editJobStep_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.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) =================================== Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Package..ctor() ---------------- I think I did saw these errors before. I'm running SQL Server Developer 2008 R2 RTM. ------------------------- I'm wondering what do I need to do to be able to run the job and how can I edit the step. Also, when I deployed the package, it created with the name Package - I'm wondering how can I give it a more descriptive name. Thanks in advance. Premature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog

what protection level you set for the package ? you can use EncryptSensitiveWithPassword as proposed in this tutorial: http://www.protalk.in/sql-server/steps-to-create-and-deploy-ssis-package-as-a-sqlagent-job/http://www.rad.pasfu.com

Naom, Check if this Fix helps. Pradeep Adiga My blog: http://www.sqldbadiaries.com

On the Hotfix page how can figure out which one I need? I think I already once visited this page and left as I could not figure out which one of the x64 I need. http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2345451&kbln=en-usPremature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog

On the Hotfix page how can figure out which one I need? I think I already once visited this page and left as I could not figure out which one of the x64 I need. http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2345451&kbln=en-usPremature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog