• 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