Sample Header Ad - 728x90

SSIS Condition that include two connections/data bases

-1 votes
1 answer
479 views
In a SSIS package , I need some sort of condition that include two connections. The simplified problem is: A simple CSV import to SQL Server, DB1, table 1( col1, col2 ). I need to populate table 1 > col2 = '1' if col1 is found in another database , DB2 > table 2 ; db2 is specified as a different connection in package. and table 1 > col2 = '2' if col1 is not found in the lookup database. any guidance is appreciated, ta
Asked by user3752281 (163 rep)
Dec 17, 2014, 12:29 PM
Last activity: Mar 22, 2025, 12:05 PM