SSIS performance

• sathiyan00

  SSCommitted

  Points: 1879

  More actions

  February 12, 2013 at 10:55 pm

  #394172

  Hi all,

  which one is good in performance

  In ssis oledb source(sql server 2008 R2)

  1. selecting table and uncheck the columns which is not required.

  2. writing sql command to fetch only required column.

  thanks

• ramv.info

  Newbie

  Points: 9

  More actions

  February 12, 2013 at 11:51 pm

  #1587295

  if source is OLEDB then sql command to fetch only required column is better for performance.

• sathiyan00

  SSCommitted

  Points: 1879

  More actions

  February 13, 2013 at 3:35 am

  #1587342

  thanks ram...

• tim_harkin

  SSCrazy

  Points: 2399

  More actions

  February 13, 2013 at 6:11 am

  #1587408

  Try them both, and test.