Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009

    Unanswered: Use DTS to Copy Tables to MSDE DB

    I have a SQL Server 2000 database and need to copy several tables to a separate database that our Marketing department can "hit" everyday without harming our live database. A consultant I hired said DTS can only copy the tables to an Access database (or to a text file that would then have to be manually imported in to a separate DB). This is proving to be problematic because the tables are very large and the size limitation of Access databases is coming in to play. Can DTS copy tables directly to an MSDE DB? Does anyone have any other recommendations on how to accomplish what I'm trying to do?

  2. #2
    Join Date
    Jun 2004
    Long Island
    script it, BCP out, BCP/Bulkcopy in, or create a linked server and select with openquery (if not terribly large amounts of data), if you do not want linked server, use openrowset.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts