April 4, 2015 at 5:16 am
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
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
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