I can run a group of packages interactively from SSIS or from the command line but when attempting to run the packages as a job some run fine and some fail. The latest cause of failure is "Description: Unable to load the package as XMLbecause of package does not have a valid XML format". It would seem that because I can run the package interactively from SSIS or from the command line and get the expected results that it is in XML format. any help on what I can to to make this work?Thanks

Hi,a quick check, please check the following thread (who is having same problem) can solve your problem.http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c93d3e10-8b26-413a-9062-ea54d4d31983http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/044b49c2-490d-4aa3-a1df-64f708705e9c/thanks- Let us TRY this | Dont forget to mark the post(s) that answered your question

Does anyone have a different solution to this? I have tried everything that has been suggested and I am still having the same issue.Dave SQL Developer

It seems like the path you are trying to run it from, is too long. I faced the same problem, i scheduled the package to run from "C:\Documents and Settings\XXXXXXXX\My Documents\Visual Studio 2008\Projects\IHS_SSIS\Data Replication\US2074_VDI" and it failed with the same error. I moved it to C:\ and it worked without any issues.

check the whether the account which is executing the job has the access rights on the folder where this ssis package exists. best way is to share the folder and access the same in sql server agent job.Please mark the post as answered to help others to choose the best. chandra sekhar pathivada | www.calsql.com (SQL Server Community Website)