I have massive data being imported to text files from the database (from production environment) using BCP command, which gets loaded to my reporting environment via bulk load method. I am trying to do some cleansing to this data, so that I could replace
line feed + carriage spacing. Since bulk loading the data caused this job to fail too many times, I am trying to rewrite this package to get the data from the text file, do some transformation etc, and then send it to OLE DB destination.
So lets say: My output column name (description) has some cleansing to do. I do know the syntax: