ETL package in SSIS to export data from a SQL Server database table . Each row in the table needs to create a new CSV file. Each file needs to be named by combining two of the columns in that row.
Take all information from one table for a certain date and import it into a new table in a different database. We will refer to the new table as Table B.
We need to keep track of all the data we have exported from Table B. For example, we export 4 rows for 24/01/2020. There will be four csv files created. The four separate files will be named by Invoice number and InvoiceType. A flag will be updated in Table B to indicate these 4 rows have been exported. We also need to record the date the rows were exported
Package needs to work in SQL Server 2012
Further brief attached
26 pekerja bebas membida secara purata $88 untuk pekerjaan ini
i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
Looks like an interesting project. I can tell you it is possible and we can make it purely dynamic so that you can just change pacakge name it will work with any table in database.