I am trying to merge multiple rows into 1 destination row during the
transfer. Can someone point me to examples on this?

Thanks.

In message <OWENLEY9DHA.1816 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Arun
<aganesan (AT) esurance (DOT) com> writes
Try this-

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)


You may also want to consider a SQL solution, and just use DTS to
transferring a staging table. This is often easier for people to
implement, and can be faster.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org