hi, i am new to sql server, .............

i have 2 databases,i have to insert data from the old database to new
database........
for example i have first_name column in new database but i have first_name,
first_name1,first_name2 ... 3 columns in old database...... i have to insert
3 columns into the 1 column in new database.......

i have done like this .......
1. In the dataflow task i have taken oledb source in which i have selected 3
columns and sorted it...
2.on the side taken another oledb1 source which have 1 column first_name and
sorted.....

what should i do to insert 3 colums in to the one column.........
please help me urgently...........

Lots of missing information here:

Using SQL 2000, 2005, 2008?
Using DTS, or SSIS? (This is a DTS forum)

If DTS, I'd use a source query to concatenate columns together.
If SSIS, I'd create a derived column to concatenate columns together.

The tutorials on MSDN should help you out here.

Best Regards,
Tom

--
Message posted via http://www.sqlmonster.com