iBinc
asked on
Accessing Remote Data from Integration Services on a Local server ??
New to SSIS and have a question about deploying a local package to a local sql server integration instance. Can you create and deploy a local package that accesses data (oledb) from a remote database?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That is quite a different question however you can find the different ways to execute a deployed package at the link below and the easiest to run packages on remote server from local machine - assuming the local machine can access that server - is via SSMS: https://www.sqlshack.com/ways-use-execute-sql-server-integration-services-packages/
ASKER