SSIS Table with dynamic number of columns import to flat file

1
votes

I've got a table with a dynamic number of columns. I have to import this table to flat file everyday. How make SSIS package, that will do this?

1
dynamicimportssisflat
How can a table have a dynamic number of columns? – billinkc
This table has not actually dynamic number of columns, just i don't want rebuild my SSIS package when i will add new column to my table – user2619796

1 Answers

0
votes

There is way around this, create a view with super set of columns and map to dataflow from source db to flat file destination and after you get the data in flat file. Let me know if you want more details please