I am new to using SSIS and i am tasked with creating a flat file that includes a header, detail and footer.
I have a SQL Stored proc that i am using and a SSIS package that i have started to read the stored proc and output a flat file.
I need help mostly on the formatting portion in the stored proc and the data flow/derived columns section.
Does someone know of an existing tutorial that helps when creating space/fixed width delimeted files in SSIS?
Attached is a sample file what the flat file should look like.