SSIS Flat File Destination
I have a requirement to output some large data sets as flat files.
They have specified the file format and I have no issues with all but one thing. They want the data files to end with "the standard EOF character that is used in Linux". When I look at the file I produce with SSIS in a text editor that shows the HEX
values the last thing I see in the file is the newlline (0A) chactare for the last line. How can I get it to insert this EOF character they want?
October 27th, 2010 10:37am
Can you use a Script Task on the Control Flow (after the Data FLow) and open the file, go to the end, insert the characher(s) then save and close it?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2010 11:21am
As Todd said you should use Script task for Inserting EOF open file, insert new character, and close it.
To convert from HEX to ASCII -- script task- but this cannot be done at file level :(
convert-hex-data-to-ascii
Hope this will help you in someway.
October 27th, 2010 2:59pm
I figured that might be the only way to go, but wanted to make sure there wasn't a setting I am missing. I wanted to avoid it because some of the files are going to be extremely large initially (serveral GB).
There is a good chance that they can live without the EOF character though.
Thanks for the reply.Tim Harris
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 8:40am
Hi Todd,
Can you please help me by giving an example script on how to open a file, how to identify the end of the file and how to insert <CRLF> to it.
thanks a ton in advance
April 26th, 2011 2:29am