Help me about Data Driven Query Task

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: LoiseauBien (guo.jia_at_gti.cn)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 09:50:54 +0800

Hi,everybody!
I want to transmit the source data of SQL SERVER 2000 to other SQL SERVER
2000 database server by Data Driven Query Task every 10 minutes.
Because the source data will be modified by data-collector at any moment, i
want to use Data Driven Query Task function to transfer the change of data.
But every time when i try,i find the DTS always inserts all of the source
data into the destination database. who can tell me why?
thank you very much.

for example:
the insert sql is like follow:
insert into gfhf_db..p_news001(seq,ctime,mtime,rtime,declaredate,f001,f002)
values (?,?,?,?,?,?,?,)

the update sql is like follow:
update gfhf_db..p_news001 set
seq=?,ctime=?,mtime=?,rtime=?,declaredate=?,f001=?,f002=?
where seq=?

Relevant Pages

  • Re: Newbie to DTS - could use some help
    ... You can then use the Data Driven Query task to issue the correct tyoe of ... destination you can select those rows that were "modified" within the ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Transform data from Oracle to SQL Server - Urgent
    ... Thanks so much for your reply Allan. ... Pump from Oracle to SQL Server and use the Data Driven Query Task. ...
    (microsoft.public.sqlserver.dts)
  • Can a DTS Data Driven Query Task use a temporary binding table?
    ... I'd like to make a DTS package that leverages the Data Driven Query Task. ... source rows from an Excel spreadsheet will be calling an SP in my destination SQL Server ... that I'd need a task to initially *create* the table in tempdb, ...
    (microsoft.public.sqlserver.server)
  • Can a DTS Data Driven Query Task use a temporary binding table?
    ... I'd like to make a DTS package that leverages the Data Driven Query Task. ... source rows from an Excel spreadsheet will be calling an SP in my destination SQL Server ... that I'd need a task to initially *create* the table in tempdb, ...
    (microsoft.public.sqlserver.tools)
  • Re: Update Table with DTS
    ... The DDQ is not complex but it does take a bit of working out. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I am new to DTS and don't know Data Driven Query at all. ...
    (microsoft.public.sqlserver.dts)