Hello Everybody,

I'm trying to use the DTS package to run an UPDATE query but it looks like
the DTS query designer isn't accepting a properly formatted query. I'm
looking at an example given on the Microsoft website that says I should use a
query like this:

*
UPDATE Account SET CompanyName = ? WHERE CustomerID = ?
*

whereas I'm trying to run a query of the form:

*
UPDATE Patient
SET AddressID = ?
WHERE
IDENTITY = ?
*

and I'm getting the lovely error titled "Package Error" that reads "Error
Source : Microsoft OLE DB Provide for SQL Server\n\nError Description :
Incorrect syntax near the keyword 'from'." which really must be designed to
infuriate me considering there is no 'from' keyword in my query.

If I'm doing something blatantly wrong, please, don't hesitate to point that
out. If you need more information, I can give it to you. I'm desperate for
this to work properly, as it's a necessary step in my dts package. Any help
would really be appreciated.

Thanks In Advance!
..Win

Looks weird does it not. So the query parses OK?

What does it say if you look in Disconnected Edit?



"Winoo" <Winoo (AT) discussions (DOT) microsoft.com> wrote

No, the query does not parse OK. The error that I mentioned is the error I
get when I try to parse the query.

I'm afraid I don't know what you mean by saying "Disconnected Edit".

"Allan Mitchell" wrote:

If you have any comments in the query, remove them.


--
Simon Worth

Winoo wrote: