Post reply

Slow Running Package

  • December 7, 2008 at 8:52 pm

    #126390

    Hi,

    I am designing a ssis package which extracts the output from the stored procedure to flat file. The output from the stored procedure has 12 million records. I wrote the stored Procedure using #table. I have selected the result set from the #table. When I execute the procedure in the SQL server 2005 it took around 20 minutes. I have created a package with OLEDB source and the output of the OLEDB source is inputted to a flat file. When i build the package and execute it is taking around 1:30 minutes to execute the package. Is there any way that I can optimize the package.

    Thanks

    Dhana

  • December 8, 2008 at 2:30 am

    #909038

    for a starter...you should replace the temp table(#table) by a table variable. That should help you.

    Thanks

    Pankaj

  • December 8, 2008 at 6:56 am

    #909122

    Instead of a table variable.If i create a permanent table will it increase the perfomance here. May be I can clear the peramanent table after the end of the package. Because i am having around 100 coumns in the table.If create a table variable,the procedure itself is talking lot of time.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply