I have an ssis package where I take csv files and load them into a DB I then have a task with a sql statement to get the data I need and export into a csv file. I need to add columns to the csv file that are not present in the db table. I'm not sure how I can add these?
1 Answers
In the flat file connection manager, go to advanced tab and add columns to your csv file. And you can add derived columns to fill them, or you can add values to your select statement
Related