We are not passing the file name, we are expecting it to pick it up from the folder. I take it from your explanation this is not the case. We...

We are getting the following error Empty file name is not legal. Parameter name: SourceFileName.

Hi I get the following error

DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 14 (E) Error string:...

Indeed it is. I am now trying to run the package using Operating system and the dtsrun within the SQL Server Agent, I am finding debugging with the SQL Server...

Here is the full error....please excuse the aaaaa\aaaa this has replaced the true user..

Executed as user: aaaaaa\aaaaaaaa. ...3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. ...

The test server has a 32 bit processor, so JET Compatabile.

The excel file is sitting on another server but I am able to read text files from the server...