I have a package that exports records from a linked server into a table
on the current server. I would like to add a piece of code to skip a
row if that key is already in the table. I attempted this but got a
type mismatch error on 'DTSSource'.
Here's the code snippet I attempted:
if (DTSSource("Emp_PK") = DTSDestination("EmpEvt_EmpFK") and
DTSSource("Evt_PK") = DTSDestination("EmpEvt_EvtFK")) then
Main = DTSTransformStat_SkipRow
end if

If I can't accomplish this, I thought perhaps I could add code that
would skip any rows that cause an error, but I'm not sure of the wisdom
in this. Nor, am I sure about the syntax for activex script.

I've double checked and my field names are typed correctly. I've not
attempted this before. Any tips or suggestions would be greatly
appreciated.
Thanks
TJ

Hello tjonsek (AT) phenom-biz (DOT) com,

I would not be doing it like this. The way you suggest processes rows 1*1.
This will hurt. If you are already using Linked servers then in your Source
Query for the datapump task you simply add a join between the source table
and the destination table and make sure that the source row is not already
in the destination. This way you do not need to process each row individually

Allan

Ok. I understand what you are saying and I understand your explanation,
just not how to execute it. I apologize. I've not attempted this
before, so I'll do a bit of reading online if I can find anything for
datapump tasks.
If you know any good sources, please let me know.
Thanks

Hello tjonsek (AT) phenom-biz (DOT) com,

www.SQLDTS.com is generally considered useful.

in the datapump task instead of specifying a table as the source you are
going to use a query that will retrieve the source rows that are not already
in the destination (LEFT OUTER JOIN, NOT IN, NOT EXISTS)

Allan

Ok. I get you. Thanks so much. I'll check out the website! Earlier I
had tried an if exists statement, but obviously didn't have everything
correct.

I appreciate it.