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 |
|
raghav99k
Starting Member
32 Posts |
 Posted - 2011-11-18 : 07:46:27
|
| Hi.I have some data in sql server table.I am selecting some of the fields, and i need to load this data into excel file with dynamic name(say with date), and i need to have some color for fields in excel with background.Excel file has to be created dynamically..Can we design this whole process using ssis. any ideas r suggestions.Thanks.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-18 : 10:33:15
|
| do you mean your metadata changes?then it would be probably worth using bcp for thisI hope your date values are generated from some table column used in query.for coloring part, you might have to use an excel macro though------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS dynamic excel file data loading.