March 4, 2008 at 8:31 am
I created a SSIS-package which more or less imports 2 excel files into a database and modifies some columns. When I excecute the package in the SSIS everything runs fine, but I need the package to be executed every morning, so I created a job in the sqlserver agent. whenever the job is starrted there it ends with an error message: the excel argument for the option 'connection' is invalid. the command parameters are invalid.
I did not make any changes on the connection strings, they look like this:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\DATA\batchfiles\Rp096.xls;Extended Properties="EXCEL 8.0;HDR=YES";
Any idea whats wrong? Thanks for any help!
Susanne
March 4, 2008 at 9:57 am
Does d:\data exist on the SQL server? Always verify that the SQL server agent account has rights to the file location.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply