Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rafferty Uy
Starting Member
23 Posts |
 Posted - 2004-11-08 : 20:15:24
|
| Hello,I'm executing a DTS package from C# and I'd like to know how you pass the specific error/exception messages in the DTS package to C# instead of just getting the generic "Task 19 failed". How do I do this?Thanks!Rafferty D. UyAssociate Software EngineerNavitaire International, LLCTel. No.: 63-2-8304532Fax No.: 63-2-8304404E-mail: raff.uy@navitaire.com___________________________________________________________________"If better is possible, then good is not enough." - John Maxwell |
|
|
Rafferty Uy
Starting Member
23 Posts |
Posted - 2004-11-10 : 19:26:49
|
| Hm... no one's answering... does this mean that this can't be done?-Rafferty |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-10 : 19:49:35
|
| DTS exposes a full COM object structure that you can program in C#. That would give you a better ability to retrieve error messages, but you would not be able to run it as a package anymore. The program would have to be compiled and run as an executeable (I think, I'm not 100% sure).Try this site, it's specifically for DTS:http://www.sqldts.com/ |
|
|
|
Rafferty Uy
Starting Member
23 Posts |
Posted - 2004-11-11 : 01:36:51
|
| hm.. i can't seem to find it in the site, is it ok if you send the exact link? :)Also, the solution you're suggesting "sounds" difficult. I just wonder if this means that there's no simpler way.-Rafferty |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-11 : 07:54:33
|
| I couldn't find a particular link at SQLDTS. I just know that whenever I get stumped on a DTS issue I usually find an answer there. Frankly if they don't have something on it then it could be there is no simpler way.You'll probably get something from Google on "C# DTS". MSDN will probably have something too. |
|
|
|
|
|
|
How to pass the error messages?