Post reply

Conversion 1 dimension Array of Bytes to string

  • May 23, 2007 at 4:47 am

    #124157

    how can i convert 1 dimension Array of Bytes to string using vb.net script

    My source have data type of byte stream [DT_BYTES]

    And my destination DAta type is STRING

    I have to use script because i am not able to convert using Data Conversion Tools..

    Please me  help to solve this problem

  • May 28, 2007 at 2:03 am

    #709171

    hi ..I tried this method to convert bytes yo string..but still it didnt work.it give this error

    [Script Component [3369]] Error: System.ArgumentException: Argument 'Prompt' cannot be converted to type 'String'.    at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)    at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)    at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)

    Dim dBytes As Byte() = Row.DATA

    Dim str As String

     

    Dim enc As New System.Text.ASCIIEncoding()

     

    str = enc.GetString(dBytes)

    Row.dates = str

     

    please can any one help wit this problem..how can i convert byte stream to string

     

Viewing 2 posts - 1 through 2 (of 2 total)

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