• 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.

    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.