Question

Point out the wrong statement.

(a) SSIS moves data as fast as your network is able to handle it

(b) It is important to understand your network topology and ensure that the path between your source and target have both low latency and high throughput

(c) Integration Services can be tuned beyond the speed of your source

(d) All of the mentioned

I have been asked this question in class test.

I want to ask this question from Integration Services in chapter Data Connectivity of SQL Server

Answer 1

Right option is (c) Integration Services can be tuned beyond the speed of your source

The best I can explain: You cannot transform data faster than you can read it in SSIS.