August 29, 2008 at 1:10 pm
I have created a job for my ssis packages. But, everytime I run I get this error message and I thing I know where the problem is .
But what does exactly this error message means
Message
Executed as user: ADHCSCDEV\sqlagt. ...n 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:05:28 PM Error: 2008-08-29 14:05:28.71 Code: 0xC0011007 Source: {C6C926D4-03B9-4194-AA66-26276825E8D0} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2008-08-29 14:05:28.71 Code: 0xC0011002 Source: {C6C926D4-03B9-4194-AA66-26276825E8D0} Description: Failed to open package file "D:\SSIS\CETOutbound.dtsx" due to error 0x800C0006 "The system cannot locate the object specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format. End Error Could not load packa... The package could not be f... The step failed.
August 29, 2008 at 1:42 pm
Just taking a guess here, but it sounds like your XML code isn't valid for some reason. Either that or you don't have the correct file location or you don't have read permissions. I am going to assume you already checked those, so I would say something is wrong with your XML. Might want to make sure that all you tags open and close properly and that everything matches for Case Sensitivity. That is where I usually have issues with XML
August 29, 2008 at 1:43 pm
or is the package build with a different version of sql server bi studio?
August 29, 2008 at 1:51 pm
To be honest with you i DOn't know. I created this job with ssis packages in my local machine, it failed. Then I mapped the server folder to my local drive , copied the package ove their , edit the job to pint to this file location. It failed. I don't have authorization to import into msdb, nor i have access to server machine directly.
I don't know?
...................................
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply