Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
revathiganesh55
Starting Member
2 Posts |
 Posted - 2012-11-16 : 00:44:59
|
| Hi friends,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.Thanks and Regards,Reva |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-16 : 23:01:56
|
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
revathiganesh55
Starting Member
2 Posts |
Posted - 2012-11-18 : 23:56:00
|
| Thanks for your reply!New columns can be added and deleted as per the business requirement.Could you plz tell me if I can modify the existing package and just change the meta data.Reva |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-19 : 02:02:31
|
| 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Access tasks in Data Flow Task dynamically