I have a dataflow where i import 2 files. The one is the file containing a couple of million records. The other file contains rows with summed values on a specific key.
The file with the millions of records is aggregated on the key, sorted, so that the 2 collums from the files can be compared. I then do a mergejoin on the key and now i have temptable with the (key,sum1,sum2). Now there must not be a difference between sum1 and sum2.
I can make a conditional split where i say ([sum1] - [sum2]) > 0.1 so that i get an output with rows where the diffence is more than 0.1.
My question is now, how do i make an action on that. If that task put out a row or more then do something (send mail task, stop further processing)
Cgpl
How to make an if in the dataflow ?
Hot Topic
- SQL Server 2000 + Tivoli TDPS error
- Combining tables
- Null Processing Option (analysis services 2005)
- Inserting Data - SQL Error 40 (VS2005 Express / SQL Express 2005)
- Unexpected function sequence error when using SQL_CO_FFO on stored procedure
- DTS transaction problem
- Custom Assemblies RS 2000
- Rounding number with ending equals 5
- Full-Text Search -- What Thesaurus does it use??
- Track Database Object Changes
SQL Server
- Cannot save my Maintenance plan
- How to return varchar(MAX) from a CLR function?
- How connect SQL server 2000 with c#.net .....?
- Trying to move a package to a new server
- Microsoft .NET Data Provider for mySAP Business Suite, PROPER Version ???
- create user only with permissions, to select, insert, update, delete, and exec sps
- Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
- Remote Connections with SQL Developers Edition
- Implications of not using Buffer.SetEndOfRowset()
- SSIS will not start after SQL Server 2005 SP1 upgrade
How to make an if in the dataflow ?
henit129409
Rykie
-Jamie
EDIT: Ahh, except that you already worked it out while I was posting this. Never mind :)
Perobas
Julian Mackintosh
HTH
Thomas