SSIS job length varies depending on data access mode RRS feed

  • Question

  • In my SSIS job I have an OLE DB Source. If I set the Data Access Mode to Table or view and select my view AGL_LedgerTrans_2016 the job takes about 11 hours to complete. If I change the Data Access Mode to SQL Command and enter the query select * from AGL_LedgerTrans_2016 into the SQL Command Text box the job completes in under 40 seconds.

    Why is this? I assume SSIS runs each in a different way but how does it work?Cheers


    Tuesday, May 31, 2016 11:07 AM