Sometimes you need to check to see if a file exists before you put the path in your database. Per local rumor this is an undocumented sproc in SQL Server. Love it, use it. 1 means yeah 0 means no. Try it out!
xp_fileexist ‘C:\test.txt’ from SSMS.
I started my SQL career working with SQL Server 2000/2005 for a large MLS Software company in Knoxville,TN. I worked with it for a few years. Now I am a SQL Server Programmer for a large E-Commerce company working with SQL Server 2008 and SSIS. My coworkers and I completed a large data warehouse in November 2009.