Post reply

Linked Server - Import Tables

  • March 16, 2006 at 4:14 am

    #113751

    Hi,

    I have been trying to improve the performance of my current SSIS project which pulls data from an existing Pervasive database.

    One thing I have read about is creating a linked server and pulling the data from the tables and importing into my sql database.

    I feel like a real noob in this area, but after creating my linked server, how do I then go about importing the tables I need? I am starting to look at T-SQL as I cant seem to create a connection to the linked server for a bulk insert task. Am I missing something and being a real bonehead?

     

    Thx

  • March 16, 2006 at 11:27 am

    #627115

    I don't know if this helps you, but your query needs to be fully qualified when using a linked server.  for example, I link to another sql server, so the table syntax is servername.databasename.objectowner.tablename.

    so an example query is "SELECT * FROM ZUSNSQL01.UTCHDREPLICA.DBO.TBLUTC_HD_DAILY_3_DAY"

    But the bulk insert task you are referring to only supports text files as a source, so you cannot linked servers as a source.  So you would just use a normal Data Flow task and use the above query methodology to get the data.  I think that using a linked server would be slower than utilizing the database connection inside of ssis though, but I am not sure.

    Shango

  • March 16, 2006 at 11:33 am

    #627116

    Thx for the heads up. I'll probably stick with my existing method of importing the data, unless I get some real verification that the linked server has any significant advantages.

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

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