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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Jose Chinchilla aka SQLJoeJose Chinchilla aka SQLJoe shared this idea  ·   ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base