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
lorenaWhy do you have to use DTS?|||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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment