Re: How do I make DTS update data changes
From: Ken Collier (anonymous_at_discussions.microsoft.com)
Date: 03/11/04
- Next message: K: "RE: DTS transform"
- Previous message: Ann: "Run dts"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Mar 2004 08:46:09 -0800
Allan,
I have a similar situation to Jim's and found your response. It looks like your option #1 will work for me, and I have created a linked server at the destination that points back to my source database (another SQL Server on a different box).
However, I cannot figure how to reference both the source table on the linked server and the target table in my staging database both in the same ExecuteSQL task in DTS. My UPDATE query requires both references. Any advice?
Thanks, Ken
----- Allan Mitchell wrote: -----
OK
You can do it a few ways but here are two
1. To UPDATE Rows then the Source identifier must be at the destination
already right?. Make a linked server from SQL Server to Access and do
UPDATES based on the values being the same(ExecuteSQL task)
2. #1 will do a blanket update so you could be updating a whole load of
rows. If you can identify in Access only those rows that have changed then
you can issue an UPDATE only against those rows in SQL Server.
--
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jim Arnold" <anonymous@discussions.microsoft.com> wrote in message
news:14b7d01c3f9f5$78ef5380$a001280a@phx.gbl...
> I am still very new to DTS and am apparently missing a
> few of the basics. I have a DTS package that runs twice
> daily. It works fine to add any new records from the
> source to the destination, however, it doesn't update any
> records that have been changed in the source. What
> additional settings or steps are needed. Note: In this
> case, my source is Access and my destination is SQL
> Server.
>> Thanks very much for your help.
- Next message: K: "RE: DTS transform"
- Previous message: Ann: "Run dts"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
