Monday, August 24, 2015

How do you eliminate special characters from a text source data file

Source File: Comma Delimited CSV file

The file has special characters which need to be eliminated before loading in the database or any further transformations.This can be done by the TEXT QUALIFIER feature of text connection Manager.






Change TEXT QUALIFIER TO #

The data is cleaned of special character #

1 comment:

  1. Wow,I think this article actually was very good and informative and properly focused on SSIS.

    SSIS Postgresql Read

    ReplyDelete