May 12, 2009 at 11:47 am
I have an SSIS package that involves a data flow step to import an Excel file into a SQL Server 2005 database. If I run this package directly from SSIS all works fine. If I try to make a it into a SQL Server Agent job task and save it as a file system or sql server package I get the following error. Please note, I am restricted from changing the Excel file names which have spaces. I am trying to place quotes around the connection string to avoid the spaces, but it still fails, if I try to just put the quotes around the xls path, then the space in (Extended Properties) is treated as the end of the statement and I get a failed path with the word Extended at the end. The word after the space (Properties) is never read. Here is the error when I put the quotes around the whole source. Setting up credentials/proxy did not have an effect.
Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option "Source=\\development5\mcd_ack\Acknowledgement Data Extract-MCD_2009-02-26-03-02-53.xls;Extended Properties=EXCEL 8.0;HDR=YES;" is not valid. The command line parameters are invalid. The step failed.
May 12, 2009 at 12:35 pm
put quotes round the entire path
Source="\\development5\mcd_ack\Acknowledgement Data Extract-MCD_2009-02-26-03-02-53.xls";Extended Properties=EXCEL 8.0;HDR=YES;"
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply