The expected output of the file is (Fixed header and details tab limited)
## Import File v:2.0
## pre-process header.
## D:2013-03-14 12:59:23
Key Product Name
71 Hollywood Flesh Latex
108 The Wizard of Oz Wicked Witch Adult Costume
204 Economy Ninja Sword
214 Sabre Tooth Bracelet
220 Monk's Cross
322 Looney Tunes Sylvester the Cat Adult Costume
To generate the output we have to use two flat file destination connections and both connection string should map to the same destination variable(use the variable).
Please follow the below steps to generate the file.
step 1. Create the dataflow task and use script component as source to generate header text.
use below script to generate the header rows
public override void CreateNewOutputRows()
{
/*
Add rows by calling the AddRow method on the member variable named "<Output Name>Buffer".
For example, call MyOutputBuffer.AddRow() if your output was named "MyOutput".
*/
Output0Buffer.AddRow();
Output0Buffer.Header = "## Import File v:2.0 ";
Output0Buffer.AddRow();
Output0Buffer.Header = "## pre-process header";
Output0Buffer.AddRow();
Output0Buffer.Header = "## D:2013-03-14 12:59:23;
}
Step 2 . add flat file destination to generate the output file and make sure to click override the data in the file check box
Step 3 . use oledb source connection to get the details rows.
Step 4. Add flat file destination to generate the output file with tab limited and make sure to uncheck overwrite data in the Flat file destination Editor ( By unchecking the box will make sure the header rows are not overwrite)
