All geek questions in one place

Where the remote SSIS package actually runs

We have an outdated Sql agent job that runs on server A. The job step points to the SSIS package on server B. In which environment does this package actually work? We assume that it is executed in the environment of the agent that calls it, but due to some observations that we see (especially related to the file system), we are not sure.

The remote package has two connections - a connection to the file system and a connection to the database.

OS - Windows Server 2012 R2.

+5
source share
1 answer

SSIS is a client service / tools, so it will work where the package is physically located.

In your case, the SQL Agent Job on ServerA runs only the package, the package located on ServerB . All data processing and data flow occurs on ServerB .

A package itself can have many connections to flat files or databases, but all data from these flat files and databases will flow to ServerB , not ServerA .

I hope this answers your question and eliminates any confusion.

+3
source

Source: https://habr.com/ru/post/1266705/

More articles:


All Articles