February 22, 2013 at 8:14 am
Hello
I am getting error when running SSIS package using SQL Server agent. Error description is "Unable to load the package as XML because of package does not have a valid XML format". When I run in the BIDS its working fine.. I tried creating the package again and again in differnt folder locations.. But still the sql server job is showing error. Also I have fixed admin role on the server instance with which i think i can run jobs. I am not sure how to check if I have permissions to access the file though.. But its a local file, so I think I dont have any permissions problem. Now as a second alternative I re created the package in a network drive and still getting the error. Please help.. 🙁
--Pra:-):-)--------------------------------------------------------------------------------
February 22, 2013 at 9:47 am
if pkg deployed using 32 bit machine then need to use 32 bit exe to run the pkg
February 22, 2013 at 10:00 am
Ya I changed it in the very first step... But still getting the same error.. 🙁 🙁 🙁
--Pra:-):-)--------------------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply