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

    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
    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 "sqlblindman"

Posting Permissions

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