Dan Crowell


I am getting an error when I try to schedule a package. I can run the package with no problems from BIDS. For some reason it is throwing an error when I try to schedule the package using SQL Server Agent. Information on how to resove this would be greatly appreciated.

Executed as user: MACHINE\SYSTEM. ...n 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:41:55 PM Error: 2007-02-19 17:41:56.01 Code: 0xC0011007 Source: {48427B5A-10F6-4054-B7EB-F0F19B90F334} 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: 2007-02-19 17:41:56.01 Code: 0xC0011002 Source: {48427B5A-10F6-4054-B7EB-F0F19B90F334} Description: Failed to open package file "C:\Documents and Settings\first.last\My Documents\Visual Studio 2005\Projects\Package 1.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 X... Process Exit Code 4. The step failed.





Re: XML Problem when scheduling SSIS package

jwelch


Does the account the SQL Agent is running under have access to that folder and file







Re: XML Problem when scheduling SSIS package

Phil Brammer

jwelch wrote:

Does the account the SQL Agent is running under have access to that folder and file

More importantly, does the account which the SQL Server service runs under have access







Re: XML Problem when scheduling SSIS package

Danny Crowell

I have another package in that folder which is successfully scheduled using SQL Server Agent. Therefore, I think the answer is yes - SQL Server has sufficient permissions.





Re: XML Problem when scheduling SSIS package

jwelch

If the package was copied in from another folder, it may still have different permissions. If you created it there, the permissions are probably fine.

Outside of the permissions, I'm not sure what would be causing this.






Re: XML Problem when scheduling SSIS package

Danny Crowell

The package was created in the folder. I do not think this is a permissions issue. I think it is some sort of XML problem due to the error message I posted at the start of the thread.





Re: XML Problem when scheduling SSIS package

jwelch

If the package XML was not correct, it wouldn't open in BIDS. Do you have any references to external files (configuration files, for example) in the package




Re: XML Problem when scheduling SSIS package

Danny Crowell

jwelch wrote:
If the package XML was not correct, it wouldn't open in BIDS.

I agree with you. However, the package opens in BIDS. I think the XML format is correct. I think there is some sort of SQL Server Agent bug causing the problem.

jwelch wrote:
Do you have any references to external files (configuration files, for example) in the package

I have references to data sources but not to configuration files.





Re: XML Problem when scheduling SSIS package

Danny Crowell

I tried this thinking it might help:

regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll

Unfortunately, it did not work. Does anyone else have any ideas





Re: XML Problem when scheduling SSIS package

Danny Crowell

I found a solution. I recreated the SSIS package from scratch. Then I was able to schedule the package with no problems.