Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 File Import Empty File Check

Author  Topic 

imtheflyer
Starting Member

1 Post

Posted - 2008-06-19 : 10:38:11
I'm reading in a pipe delimited text file. If the load is unsuccessful an email will be sent to me. The problem is when the file is empty it is unsuccessful and an email gets sent. Is there any quick way check if the file is empty and just bypass the load if it is? Any other solution? Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-19 : 11:51:08
look for File size section in:-
http://www.sqldts.com/292.aspx
Go to Top of Page
   

- Advertisement -