I've followed the steps mentioned but I'm stuck on number 5. I can't find a straight forward article or how to on how to setup a Script Component as a source...that works for me. The part I get stuck on is when people get to writing out the C# or the VB. I can't get anyone's syntax to work.
I'm using SSIS 2012 and all I'm doing is trying to add this in the footer of my file...
EOF|1167
I setup a variable to get this information. Here's the code for that variable...
"EOF|" + TRIM((DT_WSTR, 10) @[User::row_count])
The name of the variable is footer. The name of the file connection I'm using to insert the header and detail is SLVEXT.txt
Is there a good how-to somewhere that explains how to insert one line into the footer of a file? I'd rather stay away from creating a footer file and then concatenating files because that would involve an extra step to remove a footer file after concatenation. I'll keep googling in the mean time.
TIA,
John