December 7, 2010 at 1:21 am
If all the data is on a SQL server, and I designed the SSIS packages on my local PC, where does processing happen on the server or the my PC,...what I am trying to ask, must I remote to the server and run the packages from there
December 9, 2010 at 8:58 am
I believe it runs where it is deployed. Obviously there will be load wherever the data is either coming from or going to, but the processing should be the package is deployed.
December 12, 2010 at 8:37 pm
In general, processing will be done on the server where the packages are running. There are situations that you could initiate a stored procedure on a remote server that calls yet another server, but typically, where you run the package from, will be involved in the processing.
Often when you are developing on a 32 bit system and you run your package from your system against another server, 64 bit system, through BIDS, your 64 bit drivers are not used/tested and are sometimes overlooked when it comes to deployment.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply