Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
iam new

Answered iam new

  • Sunday, January 20, 2013 3:39 AM
     
     
    Sign In to Vote
    0

    hi,

    iam new to ssis performances which will give better performances when loading the data to destination

    either oleb destination and sql server destination or bulkinsert task

     

All Replies

  • Sunday, January 20, 2013 4:38 AM
     
     Answered
    Sign In to Vote
    1

    If you have not already read these articles then oyu might find them helpful -

    http://consultingblogs.emc.com/jamiethomson/archive/2006/08/14/SSIS_3A00_-Destination-Adapter-Comparison.aspx

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/9f9208ad-6371-4cdf-aed4-778b8b7eea4c/

    http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/fa541e97-40f6-4295-b911-9bb1b7cdf129

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e730f5ac-3a84-4616-8918-53793715faea/

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.
    Thanks!
    Aalam | Blog (http://aalamrangi.wordpress.com)

     
  • Sunday, January 20, 2013 4:54 AM
     
     Answered
    Sign In to Vote
    0

    Hi Hari,

       try the below links,

     http://msdn.microsoft.com/en-us/library/dd425070.aspx

     http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server

     http://henkvandervalk.com/reading-as-fast-as-possible-from-a-table-with-ssis-part-ii

    Thanks & Regards, sathya

     
  • Sunday, January 20, 2013 4:13 PM
    Moderator
     
     Answered
    Sign In to Vote
    1

    hi,

    iam new to ssis performances which will give better performances when loading the data to destination

    either oleb destination and sql server destination or bulkinsert task

    I advocate not to use the SQL Server destination: http://www.bidn.com/blogs/BrianKnight/ssis/770/why-not-use-an-ssis-sql-server-destination

    The OLEDB destination configured to use the "Fast Load" option with table lock is the exact equivalent to the Bulk insert Task and thus does not provide any advantages.

    So in short,  unless you use the OLEDB without the "Fast Load" option the Bulk Insert is the winner.

    But be aware of several other options provided by the OLEDB destination in the Advance Editor that may help achieve an even better load speed:

    Order([<column>]) option is (if used knowingly) would improve the load speed even further.

    Arthur My Blog