July 3, 2007 at 12:42 pm
I'm trying to update a table using a DTS package. I have so far a package with a data driven query to insert rows which works.
I have a package with a data driven query to update rows that doesn't work. I want to update all columns except one in the test_tbl. This is the sql I'm using:
UPDATE test_tbl
SET last_name = ?, first_name
= ?, middle_init = ?, ssn = ?, birthdate = ?, addr1 = ?, city
= ?, state = ?, zip = ?, hm_phone_nbr = ?, r_name = ?,
department = ?, companyposition = ?, employeeno
= ?, datehired = ?
WHERE employeeno = ?
With this I get error:
Operand type clash: datetime is incompatible with ntext.
Then I need to run something that will call either one or the other of these packages. Depending on whether the employeeno is in there already.
Any ideas are greatly appreciated! Thanks.
July 3, 2007 at 1:00 pm
I think the problem might be because the column I don't want to update is taking the first parameter and throwing everything else off.
When setting the transformations I thought I had to select them all, is that correct? I had an error when I didn't select the column I don't want to update. (One or more destination parameter columns had no transformation specified).
Is there a way around this? Thanks!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply