Integration services Configuration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Integration services Configuration

Integration services Configuration

Rate Topic

Display Mode

Topic Options

Author

Message

eseosaoregie

Posted Friday, February 15, 2013 6:48 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:39 AM
Points: 274, Visits: 938

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

opc.three

Posted Friday, February 15, 2013 2:25 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:27 PM
Points: 6,695, Visits: 11,711

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

eseosaoregie

Posted Friday, March 01, 2013 2:29 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:39 AM
Points: 274, Visits: 938

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

Post #1425400

aaron.reese

Posted Thursday, March 07, 2013 11:05 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 7:33 AM
Points: 234, Visits: 441

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 »

Permissions