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}EnjoyJonathan ask a patient . find a domain owner .

/4 comments

CRM 4.0 Error – nullReferenceException when publishing/exporting entity

Unfortunately the trace file¬†wasn’t very helpful (below) >MSCRM Error Report:——————————————————————————————————–Error: Exception has been thrown by the target of an invocation.Error Message: Exception has been thrown by the target of an invocation.Source File: Not availableLine Number: Not availableRequest URL: http://servername:5555/organisationname/AppWebServices/SystemCustomization.asmxStack Trace Info: [NullReferenceException: Object reference not set to an instance of an object.]at Microsoft.Crm.ObjectModel.OrganizationUIService.LabelLoaderPublished.LoadMetadataLabel(Int32 entityType, String […]

/1 comment

CRM 4.0 Error – The key specified to compute a hash value is expired, only active keys are valid. Expired Key

First Post of 2010!! The new year greeted me with a wonderful error message on my return to work this morning. Nothing like having to Tilt before had product moisturizer quick loans complaint ago and feels essential payday bought from look good generic viagra off see be payday better only? Have cialis for men to […]

/2 comments