SSIS - Does it matter where you run the job from? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

SSIS - Does it matter where you run the job from?

Author

Topic

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-08-10 : 11:46:14

I have an SSIS package that takes data from a table on Server A and dumps it into an identical table on Server B. I am running the SSIS package from a command line. Does it matter where I run the job from? What I am trying to understand is whether if I run the job from my desktop:

a) The package figures out that data goes from Server A to Server B and sends it directly bypassing my desktop OR,


------------         ------------
|          |Data flow|          |
| Server A |========>| Server B |
|          |         |          |
-----------          -----------

b) The data gets to Server B via my desktop computer.


------------         ------------
|          |         |          |
| Server A |         | Server B |
|          |         |          |
-----------          -----------
    ||                    ^^
    ||                    ||
    ||                    ||
    ||                    ||
    ||    ------------    ||
    ||    |           |   ||
    \\===>| My Desktop|===//
          |           |
          ------------

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources