Re: Newbee DTS Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: jj (zzaro_at_excite.com)
Date: 01/31/05 

Date: Sun, 30 Jan 2005 16:32:39 -0800

Thanks for your help!.

One more question.

what is a linked server?
"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:eZg2ZAxBFHA.1408@TK2MSFTNGP10.phx.gbl...
> Your situation sounds more suited to replication than DTS however, we can
> also do this in DTS
>
> You can grab the MAX(id) value using
>
> 1. An ExecuteSQL task that reads this value into a parameter
> 2. Use a linked server
>
>
> If you use a linked server then you can write the query to extract rows
> just as you would, with a few changes, if everything was local.
>
>
> If you have read things into a Global Variable you can use it in a query
> like this
>
>
> Select <col list> from table where col = ?
>
> You then map the ? to the global variable.
>
>
>
>
>
>
> "jj" <zzaro@excite.com> wrote in message news:zzaro@excite.com:
>> Hello,
>>
>> I have 3 sql servers running.
>>
>> lets call them sql server 1,2 and 3
>>
>> all 3 servers have a table with the following columns
>>
>> ID, Location, transaction id.
>>
>> server 1 and 2 collect data and populate thier tables....i would like
>> server
>> 3 to get the data from the tables on server 1 and 2 and have a master
>> table
>> on server 3 (server 3 table is made up of records from server 1 and 2)
>>
>> now before i import into the table found on server 3 i need to run a
>> query
>>
>> on server 3 and find out what is the MAX(id) and use that in the query so
>> i
>> only import records greater then the current max id aka only new records.
>>
>> not sure how to do this in DTS
>>
>> Can anyone help?
>

Relevant Pages

  • Re: Change DTS Query and getting SQL Server doesnt exist or acces
    ... I am connecting directly to the server with Enterprise manager (using ... double click on the transform data task arrow, and click on the "Build Query" ... I'm trying to update a query of the transform data task of a DTS ... >> package(I've never worked with this DTS package before). ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS - passing variable from one connection to the other connec
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... The 'select' query is in the> 'Source' tab of the Transform Data Task properties. ...
    (microsoft.public.sqlserver.dts)
  • Re: ActiveX DTS not working on Schedule
    ... DTS package. ... comes with SQL Server due to the bug in 2000 which corrupts the DTS ... '  This script uses FTP to move a file from the transfers directory ... If not errorlevel 1 If not errorlevel 2 goto 226_ok ...
    (microsoft.public.sqlserver.dts)
  • Unable to enlist in the transaction.
    ... When i execute the same DTS job on another server not running SQL Server I ... Unable to enlist in the transaction. ... Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)
  • Re: using access schema ini with DTS
    ... and yes I refresh the access database... ... SQL Server and with a scheduled event. ... Col2="PartNumber" Char Width 16 ... Underneath the covers of a DTS ...
    (microsoft.public.sqlserver.dts)