I suggest you ...

BIxPress Data Cleansing / Data Quality Framework

It would be great to be able to have a Data Cleansing / Data Quality Framework, leveraging on Task Factory TD Data Cleansing Component in which a set of data cleansing rules can be applied after all Source components. For example, after every OLE DB Source, add TF Data Cleansing to remove leading and trailing spaces, convert blank to Null, remove NonNumerics, validate values with a regex, etc..

With a Data Cleansing Framework, you can apply it to all packages, instead of doing this one package at a time.

19 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Jose Chinchilla aka SQLJoe shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base