LearnItFirst User Forum

New SQL Server 2008 DBA Course
Welcome Guest Search | New Posts | Members | Log In | Register

Export to Excel worksheets Options
lyntonjb@yahoo.com
Posted: Monday, April 27, 2009 1:07:29 PM
Rank: Newbie

Joined: 4/27/2009
Posts: 2
Points: 6
Where do you live?: Cleveland
I am using SSIS to export to excel. I have a couple of procedures one result set needs to go to the first worksheet and another to the second worksheet.
How do you communicate to SSIS which worksheet in the spreadsheet to put the results set in?

Please help.
Scott Whigham
Posted: Monday, April 27, 2009 1:30:02 PM


Rank: Super Mod

Joined: 3/20/2006
Posts: 460
Points: 1,002
Where do you live?: Dallas, TX
Have you viewed the videos over at http://www.learnintegrationservices.com on Data Flow already?
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.