Home Forums SQL Server 2005 Business Intelligence Transformation Suggestion for joining an extra column (SSIS). RE: Transformation Suggestion for joining an extra column (SSIS).
Eirikur Eiriksson
SSC Guru
Points: 182882
More actions
October 2, 2014 at 3:05 am
#1749630
k.kavitha236 (10/2/2014)Source is excel and destination is OLE DB
k.kavitha236 (10/2/2014)
In this case, my first suggestion is to use a staging table at the destination for the aggregation. Is that an option?
😎