SSIS package to update SQL table : <p>I have a file that contains Client information (client number, client name, client type, etc.) and I imported that into a SQL table.</p>

<p>Client information can change, and when it changes it changes it in the file.</p>

<p>Now, what I want to do is create a SSIS package that will read the file and search for any differences between the file and SQL table and if any changes are picked up, it needs to update the table according to the file (the file will always contain the latest information).</p>

<p>How would I achieve this? Is this possible from an SSIS perspective?</p>
