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