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...

hi..

I am tyring to convert numeric eg 20070518

TO

 datetime or smalldatetime eg 5/18/2007 12:00:00 AM

in Dts package ther wrote this script..

but i dont know how can i do in SSIS package

Function...

hi..thanks for your reply..

i am using Data conversion task ...buts its not able to convert

Byte Stream [DT_BYTES] to String[DT_STR]

It gives this error:

[Data Conversion [245]] Error: Data conversion failed while...

hi

 thanks for reply..I found a solution. I have add Script Component..There i can add new output row ..

From the result of variable i add to new output result.

eg

Dim

...