Hello, I need to export several (30) tables/views to Excel workbooks. Using the foreach loop container I can iterate over the tables or over the workbooks. The probleem is that the structure of each table is different. How can I make the "mapping" of columns dynamically ? Oh and if the data is varchar it must be converted to nvarchar. Any suggestions ? Constantijn

Hi, What you want to achieve is not possible with SSIS, Because it doesn't support dynamic data mappings. You may have to develop separate data flow tasks or create an intelligent script task which does it.Rajkumar

Hi, What you want to achieve is not possible with SSIS, Because it doesn't support dynamic data mappings. You may have to develop separate data flow tasks or create an intelligent script task which does it.Rajkumar

If you can use third-party solutions, check the commercial COZYROC Data Flow Task Plus. It is an extension of the standard Data Flow Task and it supports dynamic data flow columns at runtime. You can accomplish the transfer of all your tables with only one Data Flow Task Plus. No programming skills are required.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

If you can use third-party solutions, check the commercial COZYROC Data Flow Task Plus. It is an extension of the standard Data Flow Task and it supports dynamic data flow columns at runtime. You can accomplish the transfer of all your tables with only one Data Flow Task Plus. No programming skills are required.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/