http://stackoverflow.com/questions/16181921/dataflow-task-in-ssis-is-very-slow-as-compared-to-writing-the-sql-query-in-execu