SSIS -> Excel, large data sets

Question

Post reply

SSIS -> Excel, large data sets

Steve Jones - SSC Editor

SSC Guru

Points: 736430
More actions
October 27, 2010 at 9:23 pm

#228446

Can someone write an article that shows how you can send more than 65k rows to Excel through SSIS?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

I'll take this one.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Dugi SSCoach Points: 17998 More actions · Answer 2

Alvin Ramard (10/28/2010)
I'll take this one.

Have you done with this, I want to read your article !?

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

It's still in progress. Hopefully I can submit it to be publish on SS before the end of the week.

Now, back to Black Friday shopping.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 4

Alvin Ramard (10/28/2010)
I'll take this one.

I'm looking forward to that, Alvin. Thanks for stepping up!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

a4apple SSCrazy Points: 2620 More actions · Answer 5

Steve Jones - SSC Editor (10/27/2010)
Can someone write an article that shows how you can send more than 65k rows to Excel through SSIS?

Is this article done, or can I work on it?

Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.

Steve Jones - SSC Editor SSC Guru Points: 736430 More actions · Answer 6

Not done, but please do not submit for multiple articles. Please take one on only.