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 |
|
henrikop
Constraint Violating Yak Guru
280 Posts |
 Posted - 2007-05-22 : 03:34:08
|
| Before the "Team" is deciding to buy some expensive tools I have a question.How can I export SQL 2005 data to multiple Excel worksheets?A SSIS solution would be great, though I think CLR might be easier? Can you give a direction, or post a link?Henri~~~~There's no place like 127.0.0.1 |
|
|
YogeshDesai
Posting Yak Master
136 Posts |
|
|
henrikop
Constraint Violating Yak Guru
280 Posts |
Posted - 2007-06-30 : 03:09:43
|
| That was *exact* the information I was looking for!! Thx!Henri~~~~There's no place like 127.0.0.1 |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-01-12 : 15:27:11
|
| hi there has madhivanan's blog moved somewhere I cannot find the link.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-01-12 : 15:29:19
|
| Check his profile..I think he is here now..http://sqlblogcasts.com/blogs/madhivanan |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-01-12 : 17:03:02
|
| thanks vijay! that gets me half way in. still looking for a way to use SSIS + SSRS to dump multiple reports from report server into one worksheet for each report but all in one excel file<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-01-13 : 01:23:11
|
quote:
Originally posted by yosiasz
hi there has madhivanan's blog moved somewhere I cannot find the link.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion
I moved my blog from sqljunkies to sqlblogcastsYou can also referhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-01-13 : 11:48:42
|
| thanks madhivanan! I will check it out.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Export to multiple Excel worksheets