Home Forums Data Warehousing Integration Services SSIS speed loading Issue with "Table or view - Fast Load" option in the OleDBDestination component RE: SSIS speed loading Issue with "Table or view - Fast Load" option in the OleDBDestination component

  • January 30, 2015 at 7:16 am

    #1774340

    bouazizimedridha (1/30/2015)

    Hi,

    Description :

    I opened an existing package in visual studio 2012, and noticed on the OleDBDestination component that the selected DataAccessMode was "Table or View". The duration of the load for 150 000 lines was of about 45min.

    I switched the DataAccessMode to "Table or View - Fast Load", and the duration went down to 4 minutes.

    Now the problem is :

    Once I deploy the package to the SSIS server, it still takes 45 minutes, same as the original version of the package.

    Could it be that the option does not get set or so. Has this happened to anyone before.

    Thanks in advance !

    Apologies for asking, but are you certain that the version you deployed is the same as the one which is being executed?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.