Hello,

I wrote a DTS package that import data from excel sheet into SQl table. If
the name of the file is static everything is ok.

I need filename dynamic. To do so, I use dynamic property and use globals
variables.

I test the package into enterprise manager and assign value to globals
variables corresponding to the physical path of the excel file. I'sure the
path and filename is correct and exist. But when I run the package, I get an
error message : The Microsoft Jet database engine cannot find the object
.... Be sure that it exists and that hte filename is correct.

I do not understand. The dynamic property is well the first step of my
package.

Sql is running on my workstation and the specified path is also local.

Please Help.

Sang-Do