Export Data to Excel Through SP

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.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Export Data to Excel Through SP

Author

Topic

amrindia
Starting Member

8 Posts

Posted - 2008-04-03 : 06:54:21

Hi All

Thanks in Advance...

I want to export data from SQL Server 2005 to Excel. Now I made a sp for that, since the SP will return multiple result sets and all data (all resultsets) need to export through SSIS package.

Can anyone please help me out how to do this.

Michael Raj. A

MichaelRaj Arokiyasamy

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2008-04-03 : 09:46:46

Are you creating an SP to return data in a SSIS package? Are you sure you're using the correct approach?

amrindia
Starting Member

8 Posts

Posted - 2008-04-04 : 02:14:09

Hi

Yes, I have a SP to select data from server.

Idea is, I need to execute this sp at SSIS package and need to export data to excel.
But my sp is returning multiple recordsets, when i am trying this i am getting the first select statement only, ultimately I need the others also.
So, please

Thanks & Regards
Michael Raj

MichaelRaj Arokiyasamy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources