Home Forums Data Warehousing Integration Services SSIS Packge to locate the latest file with particle file name, unzip the file and import into a table RE: SSIS Packge to locate the latest file with particle file name, unzip the file and import into a table

  • August 20, 2013 at 11:39 pm

    #1643300

    SQLArnold (8/20/2013)

    Thank you for your reply it is greatly appreciated.

    I thought I would have a problem deleting the file after I moved it. Our DBAs allow business analysts to have minimal access but by searching again I think I might have found a solution. Everything I researched before used xp_delete_file.

    Thank you again for your time, I will give this second try.

    No need for that - you can use the SSIS-native File System Task to delete the file.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.