Post reply

how to transfer data without creating linked servers?

  • July 21, 2010 at 1:28 pm

    #142113

    i have some index frag and row count data i want to centralize for reporting purposes. i also want to set up a daily process to transfer it to a central location, but only current data. if i use a query in the data flow task from an OLE DB source then it's going to ask me to create a linked server which i don't want to do. is there any way around it?

  • July 21, 2010 at 2:30 pm

    #1196493

    Easiest way would be to build an SSIS package that walks through a list of servers using a for-each loop and using expressions replaces the server name in the connection.

    I cannot find the article link I would normally point you too, but I would be willing to walk you through it.

    CEWII

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

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