hi........

i am new to sql server, i have 2 columns fields like LIC-NO and SSN in database1 and...

HI..............

if i want to keep them in different rows.....how can do that??

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...

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...

hi.......

i have tried using the expression,but i am getting error in it...... can u give correct expression and...

Hi,,,,,,,,,,

No,i dont want like that result 123+456=123456........ i have id_num and ssn from one database to...

hi........ thanks for the reply i have done this by using derived column....but i am unable to merge them and sent to the oledb destination......

i am taking oledb source from...

hi........ thanks for the reply i have done this by using derived column....but i am unable to merge them and sent to the oledb destination......

i am taking oledb source from...