Post reply

SSIS Package for Scrambling SSN Data

  • January 13, 2011 at 2:31 am

    #243652

    Hi,

    Do any one know which component we can use from control flow of SSIS Package for Scrambling SSN data & i think it my be Script task.

    Please suggest me if any one know how to go through this.

    Thanks in Advance!

  • January 13, 2011 at 2:33 am

    #1272870

    Are you issuing a command or asking a question?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • January 13, 2011 at 3:54 am

    #1272922

    Please read the link in my signature about needing a question...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 14, 2011 at 2:13 pm

    #1273798

    dnyanesh.09 (1/13/2011)

    Hi,

    Do any one know which component we can use from control flow of SSIS Package for Scrambling SSN data & i think it my be Script task.

    Please suggest me if any one know how to go through this.

    Thanks in Advance!

    You can combine the SSN + another secret string (which you should keep private) and then apply CRC32, MD5 or SHA1 algorithm on the combo to get one-way unique value. There is free component implemented for MD5 or SHA1 hashing you can download from here. If you want to use CRC32, you may check the script here for ideas.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 18, 2011 at 4:19 am

    #1274586

    The .NET library has a host of solutions for your need. Try implementing any of the algorithm within a Script Task/Component.

    Raunak J

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply