Post reply

DTS - Text File (source)

  • February 24, 2006 at 2:51 pm

    #96663

    In SQL2000.

    Is there a way that when the DTS task (text file source) have 0 KB. It won't prompt an error?

    Error Description: Error opening datafile: The system cannot find the path specified.

     

  • February 24, 2006 at 2:55 pm

    #623332

    Using FileSystemObjects in an ActiveX script object you can check the file size and see if greater than 0 an determine what to do then, can be flow logic decision or set a specific message or any number of things.

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

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