Converting Number To String
Posted: Tue Feb 07, 2006 3:56 pm
Hi,
I need a help to over come warning message. I have a job when Iam running that job Iam getting a warning message
Surr_Key_Ann: When checking operator: When binding output interface field "AnnNumber" to field "AnnNumber": Implicit conversion from source type "int32" to result type "string[max=18]": Converting number to string.
what Iam doing in my job is Iam using a surrogate key stage to generate a key AnnNumber 32 bit integer and outputs AnnNumber to transformer stage input and converting to format like 'DMT':Annnumber to a varchar [18] so I am getting output like 'DMT1' from transformer.
can I use Modify stage to over come this problem. If I can use that Can any one tell me how to use modify stage.
Thanks,
Srinu
I need a help to over come warning message. I have a job when Iam running that job Iam getting a warning message
Surr_Key_Ann: When checking operator: When binding output interface field "AnnNumber" to field "AnnNumber": Implicit conversion from source type "int32" to result type "string[max=18]": Converting number to string.
what Iam doing in my job is Iam using a surrogate key stage to generate a key AnnNumber 32 bit integer and outputs AnnNumber to transformer stage input and converting to format like 'DMT':Annnumber to a varchar [18] so I am getting output like 'DMT1' from transformer.
can I use Modify stage to over come this problem. If I can use that Can any one tell me how to use modify stage.
Thanks,
Srinu