You can use a Lookup transform to do what you want. ideally you would only
be putting into the pipeline the rows you need and this would be governed by
ETL metadata which told you the rows to extract from source but in the
absence of this the Lookup transform should do what you want.


Thanks


Allan

"Steen Persson (DK)" <spe (AT) REMOVEdatea (DOT) dk> wrote

Hi

I need to update a table in our datawarehouse, with new records from our
production system, but I've problems creating an SSIS pacakge to do this.
Basically I just need to find the company records in our production that
doesn't exist in the Datawarehouse.
In the package I've created, I have speficied the OLE DB source and LOE DB
Destination component in a Data Flow Task. I have no problems in specifying
the table or view in source/destination if I just want to transfer
everything, but I can't figure out to specify e.g. the destination component
if I write a query in the source component. Basically I'd just create a SQL
statement like this in the source:
"SELECT IDNo, CompanyNo FROM Company C WHERE NOT EXISTS (SELECT * FROM
destination.Company CC WHERE C.IDNo = CC.IdNo)
My problem is how I specify the destination in the above query? I've looked
in BOL and tried various combinations with data flow component name,
datasource name etc. but keeps giving me an "Invalid Object Name" error. It
might be very simple and obvoius, but I just can't seems to get it right.


--
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator