December 16, 2012 at 4:00 am
Hi,
first of all i explain my goal then i'll ask the question:
I need to import data from an Oracla server to a Sql server 2005 but neither i cannot install Oracle drivers into the SQL Server server nor sql server drivers into the oracle server. The only thing i can do is having another server (front end) where i can install both of drivers.
Now the question:
Is it possibile to leave a dtsx package in the front end server and run it from the sql server server?
Thanks in advance
Simone
December 16, 2012 at 7:57 am
The server executing the SSIS Package must have all dependent software installed to support the running of the package. So, even if a package resides on a different server from where it is executing (the SQL Server) and the drivers are installed on the server where the package physically resides (the front-end server), the server hosting SQL Server still must have everything the package requires to operate. Specifically, the Oracle driver must be installed on the server hosting SQL Server if that is what is executing the package.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply