Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    1

    Unanswered: DTSX package not generating double quotes properly

    We have a DTSX package that was imported from SQL 2000 that is not generating double quotes correctly in SQL 2008. The package works in SQL 2000.

    Expected result:
    "Flat I-22, Block ""I"", Diamond District"
    Actual Result:
    "Flat I-22, Block "I", Diamond District"

    Please help. Thanks you guys!!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    DTS and SSIS packages are notoriously difficult to debug. Especially through a forum such as this.
    There are just so many places where logic could be screwed up.
    What does your original data string look like?
    If it's not practically useful, then it's practically useless.

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

Posting Permissions

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