I have a DTS that imports data from Excel into SQL. It only works if the
file name and location are exactly the same every time. I tried using the
Dynamic Properties Task, and I tried changing the 'connection.datasource' via
an active X script.

It doesn't work either way. Using the same data file EVERY time. the
package fails.

The Microsoft Jet database engine could not find the object 'Sheet1$'

If I change the physical name of the file, and then change the global
variable it doesn't work.

The JET engine must be storing additional filename info somewhere.

Does anybody know what else I am missing or how to get this to work?

--
bnhcomputing