Geek Answers Handbook

How does SSIS data flow work?

I have an SSIS package that transfers data from one database to another. The SSIS package runs on the application server.

I am going to move one of the two databases to the other data server. Will there be an impact on performance? How are data streams in SSIS, that is, does all the data go to the application server that runs SSIS, and then to the target database?

+5
source share
2 answers

SSIS is a client-side process, so if it runs on a server other than the machine on which the DBMS is running, traffic will go through the network. Your question is not very clearly formulated, but I think you want to know if moving the database will affect performance, given that the SSIS package is already running on a separate machine.

If the SSIS job is already running on the application server, which is a physically separate machine on the database server, then moving one of the databases will probably not affect performance if it does not have a significantly slower network connection than the other.

+4
source

, . - , SQL 40 12 . , 1) 2) , SQL Server.

0

More articles:


All Articles