Post reply

Script Data Conversion

  • May 15, 2007 at 8:48 am

    #117194

    Hi

    I am new to VB.net script..I want to write a script which helps me in data conversion..

    Eg

    1)Data conversion from byte to String

    2)String[Dt:Str] non unicode to String[ST_Wstr]Unicode

    3)String to Integer

    I have to do  this with Script only..

    Thank you

    dilsa

     

  • May 15, 2007 at 9:14 am

    #706537

    My question is why?  SSIS has a data conversion task that you can use to complete the data conversions you require without writing any scripts.

  • May 21, 2007 at 7:04 am

    #707795

    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 converting column "DATA" (2466) to column "Copy of DATA" (2878).  The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

    So i was thinking using script for this kind of conversion.

    His there any other solution to convert bytes to string..

    please help me with this problem

  • May 21, 2007 at 1:34 pm

    #707912

    It might help if you could provide some sample data and what your trying to convert it to.

  • May 22, 2007 at 8:25 am

    #708083

    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 Main()

    DTSDestination("DataLancamento")=Mid(DTSSource("BODATL"),1,4) & "-" & Mid(DTSSource("BODATL"), 5,2) & "-" & Mid(DTSSource("BODATL"), 7, 2)

    Main = DTSTransformStat_OK

    End Function

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

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