I would be careful on the sort transformation. Many times a sort transformation is necessary when using a merge join due to the IsSorted property not properly functioning. Jason...AKACirqueDeSQLeil ___ I have given a name to my pain...MCM SQL Server, MVP SQL RNNR...
[Forum FAQ] How to fix the Error “The column XX cannot be processed because more than one code page (65001 and 1252) are specified for it” in SSIS? [Microsoft][ODBC SQL Server Driver][DBNETLIB] General Network error. Check your network documentation [OLE DB Destination [16]] Error: ...