sql syntax for Data Driven Query
Posted on 2004-11-22
I am quite new to DTS but have decided (so far anyway) that a Data Driven Query is the solution to my problem of keeping a SQL Server database updated from an old Sybase Adaptive Server anywhere db.
We originally used the Transform data task which is great and fast but we need to ability to update the record if it exists in the destination the next time the transfer is done.
We have placed a Data Driven Query in our visual editor within EM and have set (what we think) it up correctly but when we try and run it we receive the following error :-
Error Source : Microsoft Data Transformation Services (DTS) Data Pump
Error Description : DataDrivenQuery: No query specification returned by Transform Status.
Here is the basic (for our test) query for INSERT :-
INTO TicketHeaders(TicketNumber, Contract, Currency, Exchange)
VALUES (?, ?,?,?)
Any thoughts to what we are doing wrong?