I have created a DTS Package to import 17 text files.
Two of the files fail consistently with the
error: "System Cannot Find Path Specified" while the rest
execute properly. All of the files are located in the
same place. I have renamed and recreated the files to
account for potential corruption but have had no success.

Does anyone have any thoughts as to the root of this
error and potential actions to resolve it? Thanks for
your help.

Sue

Have you tried message boxing out the values of the files. Is the value
consistent with where the files should be? Are you setting the relevant
connection property ?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sue" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I have defined the location of the files through an .ini
file. I have reviewed the file path several times and
verified the existance of the file in the specified
location. As for the connection property, I have deleted
the connection and re-established the connection, making
sure it is the same as all of the other files being
imported. Both of these actions resulted in no change in
the error.

Are you using the Dynamic Properties task?

Can you try using code?

Anything special about these two files?

Always these two files?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sue" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I am using Dynamic Properties to point to the file
location. There is nothing special about these two files
and it is always the same files. I am now writing code
to make sure all of the files were imported and to import
any files that were not. I am also checking the order of
import to see if there is a possible timing problem
between the creation of the table and the importing of
the data.