jeudi 16 avril 2015

How to remove words in a flat file from a column string of words using SSIS

I have a simple flat file like this:


Forbidden Words



Word1


Word6


Word3



Then I'm going to remove these words from a column values in a table like this(words are separated using ';'):


Original Column Values



word1;word5;word8;word2;word6


word2;word4;word1;word0;word9


// and so on



I used an OLE DB Source to read the table from SQL and do some conversion and used a script component to remove these words. I can use a Flat file source to read the forbidden words but how to use them in the script component so make a result like this:


Transformed Column Values



;word5;word8;word2;


word2;word4;;word0;word9


// and so on



enter image description here


Aucun commentaire:

Enregistrer un commentaire