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: Friday, April 11, 2014 9:27 AM
Points: 285, Visits: 1,043
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: 2 days ago @ 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1420770
Posted Friday, March 01, 2013 2:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 11, 2014 9:27 AM
Points: 285, Visits: 1,043
Many thanks. Will do some research and let you know If I find more information.
Post #1425400
Posted Thursday, March 07, 2013 11:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 10, 2014 3:49 PM
Points: 366, Visits: 577
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