Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Integration services Configuration Expand / Collapse
Author
Message
Posted Friday, February 15, 2013 6:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:06 AM
Points: 285, Visits: 1,070
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
Post #1420508
Posted Friday, February 15, 2013 2:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:19 PM
Points: 7,127, Visits: 12,655
SSIS can page data to disk if there is memory pressure. In what format the data is written though, I have no idea. Nor do I know where it is written. Search for "paging" in this article for the description and note how to monitor whether paging is occurring: http://msdn.microsoft.com/en-us/library/ms141031(v=sql.105).aspx

If you find more info in your research I would love to hear more about the topic.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1420770
Posted Friday, March 1, 2013 2:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:06 AM
Points: 285, Visits: 1,070
Many thanks. Will do some research and let you know If I find more information.
Post #1425400
Posted Thursday, March 7, 2013 11:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:34 AM
Points: 386, Visits: 624
I expect that data is written in its RAW state. This is a standard method of passing data from one package to another and is proprietry to SSIS.

Post #1428149
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse