Skipping a transformation

  • In SQL Server 2000, I have DTS packages to read in files and place them in tables.   If the file is empty, I would like to skip the data pump transformation.  How do I do this?  The Empty file has the word "None" in it and does not have as may columns as the full file.

     

    Thanks for the help.

     

    Steve

  • Could you check the file size, then use dtsrun commad?

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

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