I've worked this to death (mine) and have a final question, I hope.

I'm getting an error that say basically that my parameters are not set. My code is below. Now I thought, through my reading, that the activex passed the paramaters to my update query...but that is no so. So what am I missing....Thanks in advance.


My source is set...the query is

select abr_id, address1, address2, address3, city, state, postalcode, country
from tempaddress2

My activex script

Function Main()
DTSDestination("ABR_ID") = DTSSource("abr_id")
DTSDestination("address1") = DTSSource("address1")
DTSDestination("address2") = DTSSource("address2")
DTSDestination("address3") = DTSSource("address3")
DTSDestination("City") = DTSSource("city")
DTSDestination("State") = DTSSource("state")
DTSDestination("Postalcode") = DTSSource("postalcode")
DTSDestination("country") = DTSSource("country")
Main = DTSTransformstat_UpdateQuery

and under the Queries tab my update code:

UPDATE tblPeople
SET Address1 = ?,
Address2 = ?,
Address3 = ?,
City =?,
State =?,
PostalCode =?,
Country =?
WHERE ABR_ID = ?




Tim Sweet

Found the answer on another site. Thank you.

Tim Sweet