tag:blogger.com,1999:blog-2303058199815958946.post7153058934201867411..comments2024-03-28T10:36:35.016+01:00Comments on Microsoft SQL Server Integration Services: Encrypt column data in SSISJoost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-2303058199815958946.post-7936159789725302352015-11-03T20:47:05.783+01:002015-11-03T20:47:05.783+01:00Yes, depending on the version.<a href="https://msdn.microsoft.com/en-us/library/bb510663.aspx" rel="nofollow">Yes</a>, depending on the version.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-45976769577813114942015-11-03T20:42:08.048+01:002015-11-03T20:42:08.048+01:00You can't encrypt 'nothing', so you ei...You can't encrypt 'nothing', so you either don't encrypt null values or you first give it a default value.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-90124433727019555542015-11-02T21:30:26.677+01:002015-11-02T21:30:26.677+01:00its possible decrypt directly in database? because...its possible decrypt directly in database? because my source is an excel and my target SQL server, and i dont want decrypt data in ssis. Miguel Leanoshttps://www.blogger.com/profile/16451775240520678121noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-29977243737033110412015-11-02T19:07:41.334+01:002015-11-02T19:07:41.334+01:00and what if i have null values??and what if i have null values??Miguel Leanoshttps://www.blogger.com/profile/16451775240520678121noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-92079852091954787882015-10-31T21:11:20.470+01:002015-10-31T21:11:20.470+01:00Yes, otherwise the decrypt wont work... just try i...Yes, otherwise the decrypt wont work... just try it by running it a couple of timesJoost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-58396890016177528752015-10-23T16:45:04.348+02:002015-10-23T16:45:04.348+02:00Hi,
My doubt here is every time i run the code, d...Hi,<br /><br />My doubt here is every time i run the code, does it Encrypt the value to same value ?<br />suppose if first time encrypted value is 268BMM for first row , will it be same if i run the package second time.Anonymoushttps://www.blogger.com/profile/16574144255603850029noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-59401777894750031542013-07-25T21:55:28.542+02:002013-07-25T21:55:28.542+02:00Check the link above on tsql encryption. If you wa...Check the link above on tsql encryption. If you want to use SSIS to encrypt with Rijndael abd TSQL to decrypt then you could check out this link: <a href="http://www.codeproject.com/Articles/15296/SQL-Encryption-and-Decryption-Library-Using-Rijnda" rel="nofollow">http://www.codeproject.com/Articles/15296/SQL-Encryption-and-Decryption-Library-Using-Rijnda</a>.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-1988933123299051062013-07-25T20:13:52.547+02:002013-07-25T20:13:52.547+02:00Hello,
When I use the Script component to encryt...Hello, <br /><br />When I use the Script component to encryt the Data using SSIS. How i can use SQL query in the SQl server 2012 Database, to get the real (decrypted) Data. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-10930229711951399832012-12-31T16:26:32.002+01:002012-12-31T16:26:32.002+01:00With the encrypt script in the Script Component yo...With the encrypt script in the Script Component you create a <strong>new</strong> column that is significantly <strong>larger</strong> then the original column so you can't replace the original column. It won't fit and will give you an error (Except when your source datatype is already very large, but the actual values are very small).Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-69980489453149674682012-12-28T18:45:30.810+01:002012-12-28T18:45:30.810+01:00I am getting this error message when I use this sc...I am getting this error message when I use this script for my tutorial.<br /><br />"The value is too large to fit in the column data area of the buffer"<br /><br /> at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(Int32 columnIndex, String value)<br /> at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.set_Item(Int32 columnIndex, Object value)<br /> at Microsoft.SqlServer.Dts.Pipeline.ScriptBuffer.set_Item(Int32 ColumnIndex, Object value)<br /> at ScriptMain.Input0_ProcessInputRow(Input0Buffer Row)<br /> at UserComponent.Input0_ProcessInput(Input0Buffer Buffer)<br /> at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)<br /><br />Please advice<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-32633452624341534602011-12-02T08:40:44.061+01:002011-12-02T08:40:44.061+01:00@Anonymous: here@Anonymous: <a href="http://lmgtfy.com/?q=RSA+Encryption+in+C%23+.NET" rel="nofollow">here</a>Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-65036674978404394122011-12-01T22:31:05.911+01:002011-12-01T22:31:05.911+01:00Can somepne provide the code for RSA encryption?
...Can somepne provide the code for RSA encryption?<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-25410133872393947242011-11-30T21:17:57.468+01:002011-11-30T21:17:57.468+01:00@Anonymous: check out this forum link. Let me know...@Anonymous: check out this <a href="http://social.msdn.microsoft.com/forums/en-US/clr/thread/3df8d5aa-ea99-4553-b071-42a2ea406c7f/" rel="nofollow">forum link</a>. <a href="http://microsoft-ssis.blogspot.com/p/contact-me.html" rel="nofollow">Let me know</a> if it worked.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-13634750375285944862011-11-30T20:57:02.186+01:002011-11-30T20:57:02.186+01:00I'm getting this error while decrypting the pa...I'm getting this error while decrypting the password using VB script<br /><br />Padding is invalid and cannot be removed.<br /><br /> at System.Security.Cryptography.RijndaelManagedTransform.DecryptData(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount, Byte[]& outputBuffer, Int32 outputOffset, PaddingMode paddingMode, Boolean fLast)<br /> at System.Security.Cryptography.RijndaelManagedTransform.TransformFinalBlock(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount)<br /> at System.Security.Cryptography.CryptoStream.FlushFinalBlock()<br /> at System.Security.Cryptography.CryptoStream.Dispose(Boolean disposing)<br /> at System.IO.Stream.Close()<br /> at SC_33f43246bfb44a03a096ca265c35b8ed.vbproj.ScriptMain.Decrypt(String cipherText, String Password)<br /> at SC_33f43246bfb44a03a096ca265c35b8ed.vbproj.ScriptMain.Input0_ProcessInputRow(Input0Buffer Row)<br /> at SC_33f43246bfb44a03a096ca265c35b8ed.vbproj.UserComponent.Input0_ProcessInput(Input0Buffer Buffer)<br /> at SC_33f43246bfb44a03a096ca265c35b8ed.vbproj.UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer)<br /> at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)Anonymousnoreply@blogger.com