My past experience
At my last job we used a lot of DTS packages that we created by hand and were run as an object within our VB programs. One thing that we found out the hard way was, if a DTS package failed, the package would not return a failure message - it just sent back a integer zero, (or whatever it was) that signified everything executed perfectly.
lincoln
"Windows XP has so many holes in its security that any reasonable user will conclude it was designed by the same German officer who created the prison compound in "Hogan's Heroes." - Andy Ihnatko, Chicago Sun-Times
[link|http://users3.ev1.net/~bconnors/resume.htm|VB/SQL resume]
[link|http://users3.ev1.net/~bconnors/tandem_resume.htm|Tandem resume]
[link|mailto:bconnors@ev1.net|contact me]