InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 14:10:51 GMT20http://www.sqlservercentral.com/Forums/Topic1420508-364-1.aspxI 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.Thu, 07 Mar 2013 11:05:31 GMTaaron.reesehttp://www.sqlservercentral.com/Forums/Topic1420508-364-1.aspxMany thanks. Will do some research and let you know If I find more information.Fri, 01 Mar 2013 02:29:33 GMTeseosaoregiehttp://www.sqlservercentral.com/Forums/Topic1420508-364-1.aspxSSIS 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: [u][url=http://msdn.microsoft.com/en-us/library/ms141031(v=sql.105).aspx]http://msdn.microsoft.com/en-us/library/ms141031(v=sql.105).aspx[/url][/u]If you find more info in your research I would love to hear more about the topic.Fri, 15 Feb 2013 14:25:55 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1420508-364-1.aspxJust 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?ThanksFri, 15 Feb 2013 06:48:25 GMTeseosaoregie