Slow Running SSDT vs SQL Query

  • mbrady5

    SSCrazy

    Points: 2835

    I am building a project where I have a source data set (SQL View) that has roughly 190,000 rows. When I Select * From View, it returns the data in 3-5 seconds.

    When I try to retrieve the data using SSIS, it returned less than 5,000 rows in about 4 minutes. I killed the process after that because it was taking so long.

    Any ideas on what my issue could be?

    Thanks

  • John Mitchell-245523

    SSC Guru

    Points: 148652

    Where are you running the query, and where are you running the package?

    John

  • mbrady5

    SSCrazy

    Points: 2835

    AS a follow-up.

    The view seems to be the issue. When taking the SQL from the view, it imports in less than 10 seconds using the SQL import wizard. When doing the same with the view (which consists of the exact same SQL) it took almost 5 minutes for 4600 rows.

  • Phil Parkin

    SSC Guru

    Points: 243995

    mbrady5 (7/18/2016)


    AS a follow-up.

    The view seems to be the issue. When taking the SQL from the view, it imports in less than 10 seconds using the SQL import wizard. When doing the same with the view (which consists of the exact same SQL) it took almost 5 minutes for 4600 rows.

    Should be the same. I'd suggest that you compare the execution plans for each and see whether that gives you any clues. There may be a SET option in there that's causing things to be evaluated differently.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Viewing 4 posts - 1 through 4 (of 4 total)

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