Search code examples
sql-serverssisssis-2012ssis-2008

Identifying duplicate files based on data content in SSIS


I get files to a shared location . Every file has different meta ie. file name, date created.

I have to extract the data using SSIS if and only if file content is different than previously processed files.


Solution

  • I got work around

    SSIS execute process task and i have called FC.exe

    http://www.howtogeek.com/206123/how-to-use-fc-file-compare-from-the-windows-command-prompt/