Post reply

How can I force the result of a DTS package

  • December 7, 2005 at 4:42 am

    #67935

    SQL server 2000.

    I have a package that attempts to retreive a file via FTP, checks to see whether the file has been transferred across ( the file may not have existed on the ftp server in the first place ) and fails if the file is not there.

    However, I don't want the package to report that it has failed if this step fails.

    I've checked the available constants but there doesn't appear to be one for the package result.

    Any ideas?

    Thanks

  • December 7, 2005 at 6:32 am

    #608155

    Look for the topic "DTS Polling" on this home page of this site. It might give you some direction.

  • December 8, 2005 at 7:16 am

    #608406

    What tasks do you have in your package?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply