Yes, this is a very good alternate. Thanks 🙂

One thing is, If I don't set Fast-Load option then package is exactly rejecting the duplicate records;-)

But it takes ten times more execution time than having FastLoad option. Am looking...

I have BK duplicates. Will try implementing it. Thanks:-)

Thanks All.

I got the solution,

REPLACE([Column0],"\t"," ") will remove the tabs from source column [Column0] data.;-)

Phil,

There are tabs in the source SQL table data. I want to clean these tabs and extra spaces (Transformations) before moving data to the fixed width flat file.

<<This all assumes that the invalid data can even get into your pipeline in the first place of course.

If you have appropriate datatypes already set up for your pipeline data,...

Thanks for the quick reply..:-)