October 18, 2010 at 9:33 am
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
As long as the server running your packages has SSIS installed, you can get data from wherever you want.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
October 18, 2010 at 10:33 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply