[SSIS.Pipeline] Warning: The output column "ShareDate" (581) on output "Sort Output" (538) and component "Sort" (536) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

The subject line does not match what you have posted. Could you please clarify the problem?Tom SQL Server MVP Toronto, ON Canada

increase Data Flow task performance. yes you can check thin link and http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server http://henkvandervalk.com/speeding-up-reading-from-a-sql-ole-db-or-ado-net-data-source http://henkvandervalk.com/reading-as-fast-as-possible-from-a-table-with-ssis-part-ii good luck Sincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

increase Data Flow task performance. yes you can check thin link and http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server http://henkvandervalk.com/speeding-up-reading-from-a-sql-ole-db-or-ado-net-data-source http://henkvandervalk.com/reading-as-fast-as-possible-from-a-table-with-ssis-part-ii good luck Sincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

can you explain briefly..indu

in each link it will tell you the do's and dont's , just follow them it will help you to optimize you packagesSincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

you want to increase dataflow performance..indu