Post reply

Possible to use a server with SQL Server Workgroup installed as an oledb source?

  • October 18, 2010 at 9:33 am

    #225110

    I need to get data from servers running SQL Server worgroup. Is it possible to run a package on a server which is running SQL Server Enteprise version and point to an instance of SQL Server running Worgroup edition in an oledb connection?

  • October 18, 2010 at 9:44 am

    #1238489

    As long as the server running your packages has SSIS installed, you can get data from wherever you want.

  • October 18, 2010 at 10:33 am

    #1238526

    dndaughtery (10/18/2010)

    I need to get data from servers running SQL Server worgroup. Is it possible to run a package on a server which is running SQL Server Enteprise version and point to an instance of SQL Server running Worgroup edition in an oledb connection?

    Yes.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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