DTS File import when file is locked

[MAK]

Guys.

This has been an issue for me. It happens once in a while.

I am importing a File from a shared folder thru DTS package. Once in a while the DTS package fails due to the following error.

"Error Opening Data File: Process cannot access the file because it is being used by another process"

Is there anyway I can specify that the file is going to be opened in read only, so that the DTS will not fail?

Any other solution/suggestion?

-MAK

[JBane]

You might try copying it first, doing your import, then deleting the copy. Kind of a lame solution, but it should work.

Jeff