Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Montevideo, Uruguay, South America
    Posts
    13

    Unhappy Unanswered: Handling errors in DTS packages 2

    HI!!

    I've been working for an year or so with DTS, but it still makes me mad with it's cryptic error messages!!!!

    "The task reported failure on execution" is one of the "funny" error messages I retrieve. I've tried with the log option, but error messages stored there are as cryptic as the one shown on the screen!!!!!

    Timothy Peterson in "MS SQL Server 2000 DTS" provides code chunks that can be used to "decode" numerical error messages into something readable and understandable, but I really don't realize where should I put that code It seems to work only if you are executing packages via Visual Basic, and not using the MMC

    That's it, I really do need help with this!!!!!!! I beleive that there's someone out there that had faced and solved this problem !

    Thanks in advance
    lorena
    Last edited by soy_lore_lore; 01-05-04 at 15:16.
    Bye
    Lorena

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Why do you have to use 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.

  3. #3
    Join Date
    Oct 2003
    Location
    Montevideo, Uruguay, South America
    Posts
    13
    I'm working on an ETL process for a Data Warehouse
    Oracle "holds" the source databases and the DW is implemented on SQL Server 2000.








    Originally posted by Brett Kaiser
    Why do you have to use DTS?
    Bye
    Lorena

Posting Permissions

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