Thanks for your help. I used variables in one exec sql task and used a derived column to use that variable.

Basically i am trying to write a query that concatenate a value (a single categoryid) from the server1 category table to all the productids in server 2 products table and...

I tried with that and googled over it. But couldnt find a match for my scenario. Any link that points to that will be helpful.

Basically i am trying to concatenate...

Hi

I have tried using a subquery to get the constraint type and used top 1 to get only one record for a column. (query below)

But if i also need to...

Thanks for the reply. I figured it out.

length of the field is same in both tables.

But the default value length for one of the columns is more than what...