DDQ update
-
I've worked this to death (mine) and have a final question, I hope.
I'm getting an error that says basically that my parameters are not set. My code is below. Now I thought, through my reading, that the activex would carry 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 = ?
-
All under Queries tab,
click on Parse/show parameters.
You will see a list under destination column and parameters.
Eg. your update statement has 8 ?s, so there will be 8 parameters.
polulate destinations fields as follows.
Destination Parameters
Address1 Parameter1
Address2 Parameter2
....
-
Thank You! I don't receive the error.
It doesn't update the table but...it runs error free
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply