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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Dynamic queries in SSIS

Author  Topic 

goodsolution
Starting Member

38 Posts

Posted - 2009-11-09 : 21:56:55
Hi all,

I am creating an SSIS package to import from source to destination, in this case my source table columns are adding dynamically and my destination column are also adding dynamically, but i want to populate data for those dynamic columns as well.

How can I populate dynamically by mapping meta data columns?

can any one have any ideas on this?

Thanks


-Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-11-10 : 13:10:14
seems like what you need is a script task to create transformations based on available columns
Go to Top of Page
   

- Advertisement -