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)
 Need help with checking if file exists.

Author  Topic 

dunyamunya
Starting Member

1 Post

Posted - 2009-03-04 : 10:08:12
I am created a job in SQL Server 2000 that imports a flat SCV file from a server. Before I can schedule the job I need to add a step that would check if file exists. Does anyone know the best way of doing this? In other words, if file exists, continue the job loading it into the database, if file does not exist, abort the job without reporting failure. Thanks to all in advance.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-03-04 : 16:36:41
http://www.sqldts.com/211.aspx
Go to Top of Page
   

- Advertisement -