Joseph Michael Pesch
VP Programming

Slow SSIS Package

by 11. October 2010 21:22

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-dts/8025/SSIS-OleDB-source-as-table-view-Hideously-Slow

The difference between my SSIS package and the Export Wizard's package was
that the wizard chose an "Sql command" Data Access Method (and simply said
SELECT * FROM view)  where I chose the "Table / View" Data Access Method.

The type of Data Access Method selected apparently makes a HUGE difference
in response time.

Tags:

[None]

Comments are closed