Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sauce1979
Starting Member
47 Posts |
 Posted - 2013-02-15 : 08:50:40
|
| Just wanted to find some information on SSIS configuration. Consider this scenario: I have a datasource on server A in one region( e.g. Netherlands) and I have integration services on a server B in another region(e.g. America) and a destination source on server C in another region( e.g. London). Data is transferred from datasource on server A via integration services on server B to a destination on Server C. I wanted to know if the data is in any way persisted on the server hosting integration services. This is of concern for one of our customers. If data resides purely in RAM this ok. However if data is persisted in a temp file/log for even a fraction of second then there is an issue. Does anyone have any information/links on this.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-15 : 14:16:37
|
| it will be stored in buffers which SSIS while it gets transferred from one server to other. Thereafter buffer space will get released------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS Configuration