LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » General SQL Database Question & Answer » ssis sql server to excel

ssis sql server to excel

Options

Previous Topic · Next Topic

lyntonjb@yahoo.com

Posted: Monday, May 25, 2009 9:29:01 PM

Rank: Newbie

Joined: 4/27/2009
Posts: 2
Points: 6
Where do you live?: Cleveland

Hi All

Please help
I am trying to export from sql server 2005 to excel. But I dont know at development time how many columns I will be exporting. I have a dynamic stored procedure that creates a temporary table based on how many columns I need at run time. I cant find a way of doing this. SSIS seems to need to know the columns at dvelopment time, so does the openrowset function.

I generally land up in the region of 250 Columns and 3000 rows
My tools are sql server 2005 and SSIS.

bklr

Posted: Friday, June 26, 2009 4:32:40 AM

Rank: PFY

Joined: 1/21/2009
Posts: 27
Points: 81
Where do you live?: India

try this go to query--> result to --> result to file (ctrl+shift+f)
then execute the query then u can save the file in excel sheet

r see this links
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/import-export-to-excel.aspx
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

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.