Re: replicate 1 column to 2 columns(easy one for the gurus)

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

From: Hilary Cotter (hilaryk_at_att.net)
Date: 07/25/04 

Date: Sun, 25 Jul 2004 08:33:55 -0400

It is possible to replicate one column to two (or more) or two columns (or
more) to one column.

Why don't you post your schema on the publisher and subscriber here for us? 

-- 
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"ChrisR" <anonymous@discussions.microsoft.com> wrote in message
news:309301c47106$d9f12ae0$a601280a@phx.gbl...
> sql2k sp3
>
> Is it possible to replicate 1 column into 2? If not, then
> the questions I asked earlier about date transformations
> are pointless. I tried it using a DTS package and got:
>
> DataDrivenQuery:  The query type has already been set by
> the data pump consumer.  It can only be reset if the
> consumer setting was 'update' and it is reset to 'insert'
> or 'delete'.
> (Source: Microsoft Data Transformation Services (DTS) Data
> Pump (); Error number: )
>
>
>
> TIA, ChrisR
>

Relevant Pages

  • Re: Length of cycle for random numbers
    ... Do I need to set randn to some unique state in the very ... the generator will produce htesame sequence. ... The solution is to reset the seed every now and then using something quasi-random. ... It is a good idea to have the option of setting the seed yourself, because it means you can replicate a run if necessary. ...
    (comp.soft-sys.matlab)
  • Re: Excel 2003 graphics are invisible after loading xla
    ... I can replicate and find a solution. ... keepITcool ... > My xla doesn't do anything with grapics, ... > reset the visibility of it the whole set then ...
    (microsoft.public.excel.programming)
  • Re: Clear Style and Formatting
    ... you might have to reset the paragraphs style ... And if you want to replicate whatever Word does perfectly: ... Klaus ...
    (microsoft.public.word.vba.general)
  • Re: Wha does DFS not replicate .BAK files?
    ... there any way to reset the DFS link again, without having to replicate ... actually referring to the time a DFS referral actually lasts? ...
    (microsoft.public.windows.server.active_directory)
  • Re: Search Still Shows Deleted Docs
    ... Did you reset your index as well? ... see if I can replicate it. ... > Does anyone know why after deleting a document library they documents are ... > to the index yet they are still showing up. ...
    (microsoft.public.sharepoint.portalserver.development)