2/23/2023 0 Comments Notepad ++ remove blank lines![]() ![]() ![]() This code will simply read in the entire file to memory, then output the whole thing and overwrite the original, but without the last CRLF. The only other thing you need to do is add the below using statement at the top of the C#, right next to all of the other USING clauses. ![]() there are directions on how to get the variable name right in the comments of the function when you create a new script task, but if you need help, I can write the full code out no problem. If its different every run, you'll just need to pass in the name of the file as a variable. You can see that I hard coded C:\Temp\Gerard.txt in there for the filename, but you can sub in whatever your output csv is called. This is what you'd need in your MAIN() function. I wrote up a brief function for you that'll do it. Grouch, if you really want to remove that final line, you can do it via a Script Task from within SSIS using C#. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |