• Batch process means SSIS package ?

    If you are using SSIS, recently I came across a situation that extracting data using a view from SSIS slower but running the same view in SSMS is faster.

    "SSIS - views as data source - very poor performance or SSIS hangs".

    Please refer the below links.

    http://connect.microsoft.com/SQLServer/feedback/details/258901/ssis-views-as-data-source-very-poor-performance-or-ssis-hangs

    http://blogs.msdn.com/b/sqlperf/archive/2007/04/29/set-up-ole-db-source-to-read-from-view-efficiently.aspx

    [font="Verdana"]Regards,
    Rals
    [/font].