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.