Hope I can say it clear.
I want to use DTS to make that if the source data has been modified by
data-collector
then make the same change on the destination database.
I make follow step:
First I build connection connection1 of the Source SQL 2K Server,and
connection2 of
destination SQL 2K Server.
Second I build a Data Driven Query Task. In the "Source" property page,I
choose the source table
(p_news001) ,and in the "bindings" property page choose the destination
table(p_news001)
and in the "queries" property page I write SQL scripte in
insert,update,delete...
But when I run it,the first time ,the result is ok,for example successful
write to destination table 2300 row data.when run it second time,DTS can not
update the data in destination table,but insert all the source data,the
result is the destination table recod count is 4600,not my think 2300!
I know,is my wrong,not to set the update function correctly.
But I don't know should can i do.
I am working on finance database design ,analyze,develop.
My english is poor,and i use DTS first time.
Friends I need your help very much,thanks!
"Allan Mitchell" <allan@no-spam.sqldts.com> дÈëÏûÏ¢ÐÂÎÅ
:ehL9MmXvEHA.1264@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view] > The Queries are not the important part here. The important part is not
you
> call those queries in the Active Script.
>
> Can we see that?
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>
www.SQLDTS.com - The site for all your DTS needs.
>
www.konesans.com - Consultancy from the people who know
>
>
> "LoiseauBien" <guo.jia@gti.cn> wrote in message
> news:eBj2lnVvEHA.3908@TK2MSFTNGP12.phx.gbl...
> > 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=?
> >
> >
> >
>
>
