当前位置: 动力学知识库 > 问答 > 编程问答 >

sql server - Loading table in the particular order

问题描述:

I have to load big table (over > 2 TB) from SQL Server 2008 R2 to Oracle Exadata using SSIS. Is it possible to load it in particular order (based on 1 or two columns)?

网友答案:

If loading in order is a requirement, definitely put the ORDER BY into the query in the Data Source (probably OLEDB Source, if your source is SQL2008R2). This lets the database engine do the work.

The SSIS Sort data transformation is a performance bottleneck, which tries to operate in memory and necessarily has to load the entire dataset before outputting any rows. With the volume of data you're talking about, performance will be terrible.

分享给朋友:
您可能感兴趣的文章:
随机阅读: