July 21, 2010 at 11:25 am
Greetings,
I have developed an SSIS package that imports Excel data into SQL Server. This package runs fine on my PC, from within SSIS. When I copy the package to the machine housing SQL Server, and try to set the package up as a task, the task fails. The error listed is "Argument "Excel" for option "connection" is not valid. The command line parameters are invalid."
From what I can tell from MSDN, the Excel Connection Manager is native to SSIS, and SSIS (but not Visual Studio) is installed on the SQL Server machine. The SQL Server account has access to the location of the Excel file, although Excel itself isn't installed on the SQL Server PC.
Any suggestions?
Thanks,
Randy
July 21, 2010 at 11:27 am
Never mind, I think. I just discovered this:
For files that have the Excel 2007 or later format, the package requires the OLE DB provider for the Microsoft Office 12.0 Access Database Engine. This provider is installed automatically with the 2007 Microsoft Office system. If the 2007 Office system is not installed on the computer on which Integration Services is running, you have to install the provider separately. To install the OLE DB provider for the Microsoft Office 12.0 Access Database Engine, download and install the components on this Web page, 2007 Office System Driver: Data Connectivity Components [ http://go.microsoft.com/fwlink/?LinkId=98155 ] . For more information on the file formats that Excel 2007 supports, see File formats that are supported in Excel [ http://go.microsoft.com/fwlink/?LinkId=142930 ] .
Thanks anyway,
Randy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply