SSIS Integration

  • 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:-):-)--------------------------------------------------------------------------------

  • if pkg deployed using 32 bit machine then need to use 32 bit exe to run the pkg

  • 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