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 2008 Forums
 SSIS and Import/Export (2008)
 SSIS SQL Statement Results to same Workbook

Author  Topic 

Informer30
Starting Member

26 Posts

Posted - 2014-05-06 : 17:25:20
Hi,

I am fairly new to SSIS, I am using SQL 2008 R2 and have a requirement to produce one excel workbook which has multiple tab representing results from different sql statements.

I can set up the sql part in BIDS however i am struggling to program to get the sql statement results in the same workbook. Is there somekind of special settings I have to adhere to?

Any information required please ask...

Thanks in Advance...

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-05-09 : 05:59:05
see an example here
http://visakhm.blogspot.in/2013/09/exporting-sqlserver-data-to-multiple.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -