We receive 2 CSV files thru FTP every day. I need a SSIS package able to unzip one of the files and load the data of both of them into a SQLServer database.
Keep in mind that the import need to log errors and discard duplicates . Also these files arrives every day with different names, examples:
Skills: microsoft access programming, microsoft sql server programming, asp.net mvc
“Elan and his company have been very professionals and dedicated on his job, they were able to do an extra effort to delivered a high quality solution in a timely manner. I'm so happy with their work that i have paid a double amount of what we agreed on this project. Definetely I will look forward to work with them in the future. I recommend 100% the service they provide.”