Distributed Deployment Good or Bad?
-
In the many pounds of books I've been reading on SSIS lately, it seems most experts are recommending to install SSIS on a box separate from the SQL Service box. I understand how this configuration might be more scalable, BUT now, any data your package moves around has to be pulled over into the SSIS pipeline from the database server to the SSIS server. That seems pretty costly to me!
.
-
This is duplicate post. The question answered here.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply