Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Generate Fixed Width Flat File from stored procedure with multiple result-set in SSIS Expand / Collapse
Author
Message
Posted Tuesday, October 22, 2013 7:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 5:33 AM
Points: 1, Visits: 13

What is the best way to do this in SSIS.?

Here is an example

http://intelligentsql.wordpress.com/2013/07/24/ssis-variable-length-fixed-width-flat-files-design-pattern-with-no-scripting/

We just need reverse of this i.e to generate flat file similar to this from db with the sp which returns multiple results(header record-set,footer record-set,rows record set). each having different columns and widths.

If you can give us example that will be really helpful.

Many Thanks in advance

Harman
Post #1507124
Posted Friday, October 25, 2013 12:19 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:05 AM
Points: 285, Visits: 334
Hi Harman

I've built quite similar solution to extract invoices for printing work. The main goal for me was to create stored procedure which casts
all parts (header, item details, subtotals, footer) in the same data type.


Regards
Milke
Post #1508565
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse