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

  • TM002506 = this part of the filename changes

    Is it always the same length?

    Is it always the last part before the zip?

    you could strip the .zip from the filename and then find the strpos of the last period (.) and take everything to the left of that as the filename,