I have a package where the number of columns in DB tables could be changed. I want to change the meta data of data flow task dynamically. Also the mapping details will be in a seperate table as the source and destination column names need not be same. Could anyone please help me on the same.
you cant do it unless you create the data flow objects on the fly programatically in a script task. you need to call library functions to refresh metadata each time inside script task. I cant understand why your table structures are so varying though!
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
you can modify package and edit metadata to add or remove columns. Whenever table structure changes, open package in BIDS/SSDT and click on source task and it should fix errors automatically and you just need to add the new columns.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Access tasks in Data Flow Task dynamically
Posted - 11/16/2012 : 00:44:59
