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)
 To HOLD Multiple Resultsets in SSIS

Author  Topic 

8022421
Starting Member

45 Posts

Posted - 2011-02-18 : 07:05:18
Hi,
I have a procedure which results a Header Record, a detail reocrd and a Trailer record, there are three result sets. We are not supposed to change the stored procedure. Is it possible to hold the result set through any task and write the result sets to a Flat file. Can you please help us on this.

Thanks
Dhana
   

- Advertisement -