Friday, February 17, 2012

Deteted file still imports

Have created a Job with 2 Steps. Step1 imports data into a table from a text
file on another drive. Step2 deletes the file. All executes fine and the
text file disappears from the other drive. If I execute the Job a second
time, the same data is imported even though the file no longer exists. How
can this be'Never mind. I found the issue. Forgot to modify DTS pathway!!!
"Ray" wrote:

> Have created a Job with 2 Steps. Step1 imports data into a table from a te
xt
> file on another drive. Step2 deletes the file. All executes fine and the
> text file disappears from the other drive. If I execute the Job a second
> time, the same data is imported even though the file no longer exists. How
> can this be'

No comments:

Post a Comment