Use Aggregate or lookup?

Hi All,

I want to check if a row already exists for a column value. A flat file source will provide a single column-single row that contains a string value.

What I want to do is perform this aggregate query:

SELECT Count(*) As MyOutputcolumn WHERE MyDatabaseColumn = MyInputColumn

It seems like either the Aggregate or Lookup Transformations should do this, but I've not figured out how.

All help will be appreciated.

Roger

RookieDBA
Hi Again,

How would I reference an input column in a query

TIA,

Roger
Sergey Pikhulya

Not exactly sure what you mean but perhaps this will help: http://www.sqlis.com/default.aspx 311

-Jamie
newboy
Lookup will do it. The rows that have matching existing value in database will be redirected to default lookup output. The rows that don't have matching value will trigger an error or will be redirected to error output, depending on the error disposition settings.
Kunk
Thanks, Michael!

I'll give that a try.

Roger
Use Aggregate or lookup?