Home Forums Data Warehousing Integration Services SSIS check if file was already loaded ? RE: SSIS check if file was already loaded ?

  • September 26, 2013 at 1:03 pm

    #1653725

    etl.laptop (9/26/2013)

    I want to make a package to load some text files into a database table. Any suggestions on how I can check if a file has been loaded already or if a duplicate file exists, then don't load the duplicate ?

    Thanks.

    After loading a file, move it to an archive folder (and rename it to include the load date in the file name). Then you can't load it twice.