Alerts in ssis package
Hi Friends, Join table1 with table2 on name and id Alert for: --any rows from the table1 that are unmatched in the table2 data --any ambiguous matches, meaning that there are multiple id's in the table2 table that match the name from the table1 For a match, output the most recent table2 entry including all fields from the table. Please give the solution ASAP. Thanks in Advance. Lakshmi
July 5th, 2012 8:02am

Are the source of your package is some SQL tables? In that case, you can use "Execute SQL Task" where you can write your own SQL queries based on the joins, error checks etc. and use as Source for the package for further processing. In that sql query, depending on your need you can ftch only the matched queries. regards joon
Free Windows Admin Tool Kit Click here and download it now
July 5th, 2012 8:36am

hey, I would store records on ado recordset, then loop through records using foreach ado recordset compare the record and output (map a variable to ouput) an id 1 (meaning it's true for condition 1 - --any rows from the table1 that are unmatched in the table2 data) or 2 (for condition 2). then have a precedence constraint for condition 1 and another for condition 2. You can perform this check at data flow level or control flow level. at data flow, you can use a conditional split whilst at control flow you can use precedence constraint expressions Data Warehouse Developer| Nedbank, South Africa
July 5th, 2012 10:30am

Hi, My two tables from Ole db source only, Every alert should goes to Flat file destination, Particular share path location. My plan is in data flow task, I took ole db source and flat file destination Inside the ole db source i wrote the join queries as for two alerts. Is it correct way to create a package? Please give me solution any other way. Thanks in advance Lakshmi
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2012 1:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics