Post reply

link server data export out to excel file

  • October 2, 2006 at 9:25 am

    #91870

    since I plan to use the reliable capacity of the sql server, I created a link server to connect to ms access. i want to set up job to manuiplate the data and export the data out monthly.  While i used dts wizard, it did not give me the option to select the sql link server. thanks.

  • October 4, 2006 at 3:50 pm

    #664198

    Linked servers are for internal (transact-sql) use.  As in stored procs or SQL code you send to the primary SQLServer. If you want to make use of tables on a linked server you would send SQL commands to your SQLServer referencing the linked server table.  E.g. "INSERT INTO otherserver.db.owner.table SELECT a, b FROM tablex"

    DTS is an external process.  If you want to get to tables in your access database from DTS, set up a separate connection to with an ODBC DSN for that Access database.

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply