Hi,

I try to import data fron an excel file into a table in Sql 2005 Database
I create an SSIS and export the SSIS on the server
When I execute the SSIS everything works fine
Soon as I create a job to exectue the SSIS
I received this eroor message

da is a domaine administrator

Executed as user: FN\da. Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All
rights reserved. Argument "Excel" for option "connection" is not valid.
The command line parameters are invalid. The step failed.


The connection string for the excel file is :

Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=I:\3RDPARTY\AnnuaireTelephonique.xls;Extend ed Properties="EXCEL
8.0;HDR=YES";

I also change the map drive I for
\\ServerName\3RDPARTY\AnnuaireTelephonique.xls
Still does not work. I got the same error message

Do you have any idea!

Thanks in advance.

Does your server have the correct drivers (Jet, etc) to read an Excel file?
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"GC" wrote: