Solved

Does SSIS running  pump data to local machine

Posted on 2011-02-15
1
436 Views
Last Modified: 2012-06-27
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!
0
Comment
Question by:mdoolittle
1 Comment
 
LVL 6

Accepted Solution

by:
MuffyBunny earned 500 total points
ID: 34898667
It's always best for the package to be located on the server with the db instance you're going to hit up, but the overhead of doing it across the network really depends on what all is going on in the package.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now