Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2011
    Posts
    2

    Unanswered: Very Slow Data Flow Task

    Hi,
    below is a brief overview on the environment that we have:
    SQL 2005 server is been used.
    SQL 2005 SP2 is installed.
    Database size: 1.2 TB
    Temp_Table size: av. 2.7 GB, av. No of records: 3500000
    Destination_Table size: 400079 MB Row Count: 535851739, partitioned and there is no PK constraints.

    we have a .dtsx package that do some tasks and at the end there is a "Data Flow" task that do nothing else then moving the data from the Temp_Table to the Destination_Table this task is taking around 3 days to be completed !!
    can you please advise what could be going wrong?

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Have you tried executing the INSERT statement in SQL?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Nov 2011
    Posts
    2
    No We didnt try the insert since it is a production environment, do you think the insert will be faster?

  4. #4
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Don't you have a test environment? I don't know if it will be faster.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •