May 23, 2007 at 4:47 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy