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