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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2008-09-22 : 02:15:01
|
| Hi Pals,Small help needed.Using SSIS can i generate Excel data files dynamically.I have 3 tables in my database.Table_1Table_2Table_3I need to generate 3 excel files with file names same a table names but with .xls extension. Can we generate the connection managers dynamically and map the columns to the corresponding excel file.Currently i am taking 3 connection managers and creating the 3 excel templates in before hand and running the SSIS Package which accomplishes my task. But in future i may need to export more tables then what need to be done. Can anyone guide me on this regard.Thanks in Advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-22 : 05:03:43
|
| i think what you want is a ForEachLoop container with ADO .NET Schema Rowset enumerator. have a look at explanation in books onlinehttp://msdn.microsoft.com/en-us/library/ms141724.aspx |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2008-09-24 : 04:58:25
|
| Thanks for the response..NET is something beyond me.Can we implement the same logic using pure T-SQL commands? |
|
|
|
|
|
|
Using SSIS can i generate Excel data files dynamic