SSIS:BI Env.:Performance Tuning SSIS

SQL Server Integration Services SSIS Best Practices

Refer Source Video: Free SQL Training - Performance Tuning SSIS

Graphically deselecting column does not take out column, in SQL query specify the columns.Its a Client Side filter, so it pulls all data across network.

oledb source: Table or View
SQL Command:
Select * From tablename
                        [ instead for performance: Select col1,col2 from tablename]

Data Flow Task
Source - Advanced editor - Input Output Properties - column:Fastparse

For each individual column the above step need to be repeated.Fastparse will trust data being correct and load , it improves performance a lot but if any row bad then it will fail and need to rollback.

--
Refer Source Video:SSIS & SSAS BI Platform Performance Tuning

OLTP -(SSIS) or TSQL ->DW->SSAS cube<-Reports(Share point Portal,Excel etc.)

SSAS Cube in separate server  for cube to process faster.
Using TSQL fine , not necessarily only SSIS component.
Source - 'FastParse' can be used if  data is correct.
Packet size- SQL Server 2008 ( 2 types compressions: datatype ( Select data fast , Insert slow: integer takes 1 byte instead of 4 bytes) Page Compression:WinZip does for files.