Post reply

row count in char

  • April 4, 2015 at 5:16 am

    #306454

    i have 1 variable whch is integer.

    i am using row count transformation and adding values to this variable.

    now i want this variable to char(8) instead of int.

    how to do it in ssis,what data type i need t use, or do i need t convert it to chat

    i am passing this into script component, so want it as a variable only

  • April 4, 2015 at 7:20 am

    #1788737

    coool_sweet (4/4/2015)

    i have 1 variable whch is integer.

    i am using row count transformation and adding values to this variable.

    now i want this variable to char(8) instead of int.

    how to do it in ssis,what data type i need t use, or do i need t convert it to chat

    i am passing this into script component, so want it as a variable only

    Quick suggestion, use a Data Conversion Transformation

    😎

  • April 4, 2015 at 7:56 am

    #1788739

    data conversion i can do on column this is variable

    is there ay way i can do in script component ,i am using visual basic 2010

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

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