Link to home
Start Free TrialLog in
Avatar of mdoolittle
mdoolittle

asked on

Does SSIS running pump data to local machine

Where is the best location to actually RUN an SSIS dtsx script? On the machine where the database resides or any machine? Let's say I have server A and B-   both have SQL Server installed. Data is pumping from table on Server A into holding table also on Server A. Will it be faster actually running the script on A- or if I run it on B or even  C (my desktop with Integration Services Development Studio)?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of MuffyBunny
MuffyBunny
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial