Microsoft SSIS (SQL Serve Integration Services) is a platform that is built into the SQL Server database that enables the effective integration, transformation and migration of data.Hire SSIS Developers
Hi we already did the 2 phase of this project where we needed to generate the Dtsx package using C#. This is the requirement for phase 3 where we need to move the csv file to a destination table. We have multiple csv files that needs to be moved to a table with little filteration. Now since creating all those package manually is a time and recource consuming task we need to geerate the DTSX programitically as all the packages are of same design just the matadata of csv file will be different each time. I have reference for the phase 1 and phase 2 as well if any case you need it Refer it: I will also share the final Dtsx that is needed once we had a first round of talk.