SSIS Integration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SSIS Integration

SSIS Integration

Rate Topic

Display Mode

Topic Options

Author

Message

prathibha_aviator

Posted Friday, February 22, 2013 8:14 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:12 AM
Points: 95, Visits: 223

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.. Sad

--Pra

--------------------------------------------------------------------------------

Post #1423086

bangsql

Posted Friday, February 22, 2013 9:47 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:45 AM
Points: 27, Visits: 369

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

Post #1423137

prathibha_aviator

Posted Friday, February 22, 2013 10:00 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:12 AM
Points: 95, Visits: 223

Ya I changed it in the very first step... But still getting the same error.. Sad

--Pra

--------------------------------------------------------------------------------

Post #1423143

« Prev Topic | Next Topic »

Permissions