Member Avatar for dougancil
dougancil 0 Junior Poster in Training

I have a SQL DTS job that runs nightly. What this is supposed to do is to copy from Database1 to Database2 and to overwrite anything that was in Database 2 previously. This was set up as an import/export job. The process runs nightly as it's supposed to but apparently it's not overwriting the new data in database2. Anyone have any suggestions as to what to do to make sure that it not only copies the new information but also overwrites the old information.

Thanks

Doug

  • 1 Contributor
  • 0 Replies
  • 73 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.