DTS Transform Data Task - Lookup Help

[eao]

I'm not very familiar with DTS, but thought it was the right tool for this job. I am trying to import data from one database to another, and the target table has a primary key called Sequence (int). I wrote a lookup that says:

select max (sequence) + 1
from Customer

...and the ActiveX script looks like this:

Function Main()
	DTSDestination("SEQUENCE") = DTSLookups("SEQUENCE").Execute()	
	Main = DTSTransformStat_OK
End Function

Do I need to link both a source and destination column for this task? I don't have a source column mapped because there isn't a corresponding field in the source table. Does this cause the query to run once per record on my source table?

 

[eao]

Do I need to use a multiphase data pump for this task?

 

[eao]

Nevermind, I'm all set. My lookup query was bad.