Error Handing The File Does Not Exist.

I am having a having time with a error handling statement: The code pretty much does a loop through my picture and imports them into the database My only problem there is not a photo for every id# so when I get to a certain point it bombs "See Error After the Code" Thanks

use consumer
go

declare @jpg as int, @query varchar(1000)
Set @jpg = 0
While @jpg < 4500
begin
set @jpg = (@jpg + 1)

set @query = '
insert photo (id# ,ImageName ,ImageFile)
Select ' + cast(@jpg as varchar(10)) + '
, ''' + cast(@jpg as varchar(10)) + '.jpg' + '''
,bulkcolumn
from Openrowset (Bulk ''' + 'D:DataPics' + cast(@jpg as varchar(10)) + '.jpg'', Single_Blob) as ImageFile'

select @query
exec (@query)
end



(1 row(s) affected)

(1 row(s) affected)

Msg 4860, Level 16, State 1, Line 2

Cannot bulk load. The file "D:DataPics33.jpg" does not exist.