Converting Microsoft.SqlServer.Dts.Pipeline.BlobColumn to String In SSIS using C#

Just a extremeley useful snippet of code that will convert your blobs to Strings. This is frequently used when importing the notepad/description type data from legacy systems.{codecitation style=”brush: javascript;”}if (!Row.Description_IsNull) {cont.description = System.Text.Encoding.Unicode.GetString(Row.Description.GetBlobData(0, Convert.ToInt32(Row.Description.Length)));}{/codecitation}
Enjoy
Jonathan

ask a patient . find a domain owner .

4 comments

Leave a Reply

Your email address will not be published.