Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
squashjunkie
Starting Member
9 Posts |
 Posted - 2010-10-04 : 06:47:24
|
| I am getting the following error when connecting to an excel file - the connection is a variable set in a foreach loop containerOption "Source=D:\Upload_Dump\XXXXXX.xls;Extended" is not valid. The command line parameters are invalid.the file is present and the package runs perfectly well in design mode. Running the package through the SQL Agent gives this error, so it could be security, but I can't see why as I have other packages which import succesfully (also excel files) from the same directory.Any ideas?Thx"Do or do not. There is no try" |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-10-04 : 12:02:03
|
| Is the D drive on the server or your local machine?If it is on your machine, try using the UNC path instead of D:CODO ERGO SUM |
 |
|
|
|
|
|
ForEach Loop with Excel