hi
sorry for not being clear. I am trying to build a ssis package where after imported to sql table the excel file should go to archive folder(to have a history of processed files). My source file is excel and destination is mssql.
I have solved this issue by using file system task after my data flow task.
Appreciate your reply
Thanks