SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

On the Fringe

Chim Kalunta is a Database Systems Developer and Independent Consultant working out of the UK. An MCITP: Database Developer and an MCITP: Database Administrator, he can be reached at chimkalunta.com.

Archives: April 2017

Custom Handling Flat File Output of an SSIS Package with the Script Component

I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a flat file from an SSIS Package.

My initial thoughts were to output the file, pick it up with a Script Task in the Control Flow, opening and manipulating the data. Read more

0 comments, 2,081 reads

Posted in On the Fringe on 2 April 2017