Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Jan 2005
    Location
    Atlanta
    Posts
    58

    Question Unanswered: DTS -- unpredictable order of records -- why?

    Using bcp to load data from a flat file into a database table will load the records in the exact same order as they are in the flat file; whereas, a DTS package may not load the records into the table in the exact same order as they are in the flat file. Why? ... the table has no keys or indexes ... the DTS package was created with MS SQL 2000 and is now being used in MS SQL 2005 ...

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    as brett will tell you...

    the order of the data in the database has no meaning.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by Thrasymachus
    the order of the data in the database has no meaning.
    I agree as well. If you need a certain order in your data, you'll have to use ORDER BY in your SELECT. That's the only way to guarantee an ordering of the records.

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    DTS is more sophisticated than bcp. It's likely that DTS is using multiple threads, which would lead to rows being sent non-sequentially.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by jezemine
    DTS is more sophisticated than bcp. It's likely that DTS is using multiple threads, which would lead to rows being sent non-sequentially.
    Stop it, you're killing me

    >> DTS is more sophisticated...

    DTS is a piece of garbage
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    Come now Brett. More sophisticated does not mean better. Master Peice Theater is more sophisticated than Monday Night Football, but on Mondays I am watching ESPN and not PBS.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    DTS is more COMPLICATED than SQL.

    And you can find a lot of usefull things by picking through garbage, so don't dismiss DTS just because of that.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    I use it to suck up spreadsheets once in a while.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  9. #9
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    I prefer bcp over DTS just for simplicity's sake. However lots of people use DTS and find it useful.

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    For what DTS allows...the ability to allow "developers" the ability to convert a simpl bulk load process into basically a cursor based process, DTS is a piece of garbage...it allows for VERY ineffecient coding

    The games on Monday night Suck...go watch PBS

    Tonight's PBS has got a great show on Vikings, followed by a Frontline about Iraq

    And what does it say about DTS when the mothe$hip bails on DTS?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  11. #11
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    ms didn't bail on dts, they just renamed it ssis.

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by jezemine
    ms didn't bail on dts, they just renamed it ssis.

    That's not true, it's a complete rewrite...can you migrate a dts package to 2k5?

    As pure VB you can, otherwise, no, you can't
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by Brett Kaiser
    DTS is a piece of garbage...it allows for VERY ineffecient coding
    Read the forum threads, Brett. By that definition SQL is a piece of garbage!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  14. #14
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    or any other programming language for that matter. all technologies can and will be misused. that doesn't mean the technology itself is useless.
    Last edited by jezemine; 10-11-06 at 01:42.

  15. #15
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    DTS is a wizard, like Access it leads you down a path not really requiring any background...

    Do what you will

    My advice is to stay as far away from DTS as possible

    But that's my opinion

    MOO
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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