none
Encryption in SSIS Package

    Question

  • Hello,

    I want to import data from a excel source to SQL Server 2005 using SSIS.  Among all the calls columns to be imported, there is 1 column which needs to be encrypted using asymmetric encryption and stored in destination table.  Can anybody guide me how to  program SSIS package using encryption function.

    Wednesday, December 06, 2006 10:15 PM

All replies

  •  JatinShah wrote:

    Hello,

    I want to import data from a excel source to SQL Server 2005 using SSIS.  Among all the calls columns to be imported, there is 1 column which needs to be encrypted using asymmetric encryption and stored in destination table.  Can anybody guide me how to  program SSIS package using encryption function.

    I think Donald Farmer's book contains some information on how to do this. You'll be able to find it at all the usual places.

    -Jamie

     

    Wednesday, December 06, 2006 10:48 PM
    Moderator
  • You would need to use the Script Component, so you can use VB.Net to do the work.

    Have you found out how to write the encryption functions in VB.Net, if not try this-

    Walkthrough: Encrypting and Decrypting Strings in Visual Basic
    (http://msdn2.microsoft.com/en-us/library/ms172831.aspx)

    Then just wrap that into a Script Component.

    Thursday, December 07, 2006 9:31 AM
    Moderator
  • Hello Jamie,

     

    Could you please get me the name of the book. 

     

    Thank You

    Jatin Shah

    Friday, December 08, 2006 7:26 PM
  •  JatinShah wrote:

    Hello Jamie,

     

    Could you please get me the name of the book. 

     

    Thank You

    Jatin Shah

     

    http://amazon.com/s/ref=nb_ss_gw/102-7891523-4086513?url=search-alias%3Daps&field-keywords=donald+farmer

     

    Friday, December 08, 2006 8:26 PM
    Moderator