Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    41

    Unanswered: Import Files Do Not Exist

    I have a job that calls about 5 DTS's. Each DTS imports a text file. The problem is that some of the files may not be there every day. How do I exit the DTS without an error if the file does not exist, but I want my job to keep running...

  2. #2
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    how about using an activex task to check for file and if file not found then Main = DTSTaskExecResult_Success, each of this task will then trigger the respective DTS package.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •