Hi Wildh,

this is the code I've written in hte SQL task.

DECLARE @chkfile INT

DECLARE @exists BIT

EXEC @chkfile = sp_MSget_file_existence 'C:\Documents and Settings\144022.CTS\My Documents\timesheet_list.xls', @exists = @exists output

IF @exists = 1 --...

Hi,

Can you tell me where I should write the code in a package? When I tried writing it in SQL task, it throws some error stating syntax...