Integration services Configuration

  • 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

  • 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

  • Many thanks. Will do some research and let you know If I find more information.

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply