I would like to update my table from external data. My SQL 2005 query is like: UPDATE table1 SET Photo = (SELECT *FROM OPENROWSET(BULK 'C:\Photo\photo1.jpg', SINGLE BLOB) AS Photo) WHERE EmployeeID = 0001
For some reasons some photos are missing from the directory and I would like to skip when executing the next UPDATE statement but the query stop after getting the error. Msg 4860, Cannot bulk load. The file "C:\Photo\photo1.jpg" does not exist. Any help to skip the error and move to next row?