Concatenate the int in derived column

[sqlintegratonservice]

hi..........

i have to send 2 values from one database in to the 1 value of another database.......but they are int values.........when i am using derived column and concatenate they just adding up.........if i am using "" symbol in between them it is showing error in derived column.............my destination datatype is int.......can anyone help me ..........

Thanks
shravani

 

[RiverGuy]

It doesn't make much sense to concatenate these two integers into one. In this scenario,

1 and 11 = 111

also

11 and 1 = 111.

That being said, I would keep these as separate columns in the destination.

 

[sqlintegratonservice]

Hi,,,,,,,,,,
No,i dont want like that result 123+456=123456........ i have id_num and ssn from one database to cust_id in another database........so i have 2 moves 2 values in to 1 column...........
how can i do that???

thanks

 

[MDXer]

show us your input and your desired output. Either way you are asking for trouble doing it like this as the values may lose their distinction.

That being said to do this you must cast your values to varchar do the concat then you can output them as a varchar or cast them back to an int.

 

[sqlintegratonservice]

hi.........
(DT_STR,50,1252) ( (DT_STR,10,1252)[ [LIC-NO]] + (DT_STR,10,1252) [SSN] )

i am using the above expression in the derived column and LIC-NO and SSN are the columns i need to send and datatype i selected DT_STR........but also it is showing in red........

how can i write the expression??

 

[sqlintegratonservice]

hi..........
i have LIC-NO and SSN fields for all the customers in the database 1 and i have to send them to database2 into the CUST_ID column..........

for example,for a customer with id 1 have LIC_NO:234523 and SSN:123456,i have to display both the fields
in the CUST_ID field.........may like this 234523,123456.........or if possible display the 2 fields in different columns........
please help me.........

 

[MDXer]

If you mouse over the expression it will usually say what is wrong. My Guess is going to be the [[LIC-NO]] column. try just a single brace.