Link to home
Get AccessLog in
Avatar of Jim Horn
Jim HornFlag for United States of America

asked on

SSIS: Update query using two OLEDB data sources from different db's

Hi experts

SQL 2005/SSIS, I have two OLE DB sources that are same server, different db's (different connections), and have common keys.

I'd like to update source1.AColumn to source2.AColumn, JOIN on the related columns, and am trying to figure out the best transformation to pull this off.

Thanks in advance.
Jim
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of Jim Horn

ASKER

>why 2 sources for same server?
Different databases, and we're using a tool that table-drives the connection objects, and we're trying to avoid hard-coding any database names in T-SQL.

>http://www.sqlis.com/311.aspx
I figured out the Method 1: Merge Join already; and am trying to improve on it.
Your article link is correct.  Thanks.  -Jim