I am getting the following error message when I try to run a script that writes to an excel file calling my Package with a SQL 2008 JOB.
Executed as user: xxxx\xxxxxxx. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option "12.0;HDR=YES;" is not valid. The command
line parameters are invalid. The step failed.
This same package runs correctly if I execute it in dev mode in BIDS. I had to set 64bitmode to false in Dev mode to get it to work. I set executable options in the job step to 'run in 32 bit mode' The error message indicates to me
it is trying to run in 32 bit mode which should be correct but it doesn't like the extended parameters. .
Here is my connection string from the data sources tab on the job
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\xxxx.xlsx;Extended Properties="EXCEL 12.0;HDR=YES";
This was filled in ny the connection object for me. I have read the article closely at
http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html and still can't figure out what I need to change.
View Complete Post