I need to create an SSIS package that takes a table name as a parameter and exports out its data in a CSV file.
The challenge is that if I use a data flow task and a flat file connection manager (for csv export), I have to specify the file/table structure. I will not know the table structure until the run time because it is input specific.
Has anyone had a similar problem and implemented a solution?
I was thinking along the lines of using C# in a script task, but could not come up with a full blown solution.