I CREATED A SIMPLE DTS PACKAGE TO UPLOAD AN TEXT FILE INTO A TABLE IN SQL
SERVER DATABASE THEN SAVED THIS PACKAGE AS A VISUAL BASIC MODULE FILE. NEXT I
CREATED A VB PROJECT AND ADDED THE ABOVE MODULE TO THE PROJECT AND RAN IT.
THE PROJECT DID RAN TO THE END, AND DID NOT SHOW ANY ERROR MESSAGE, BUT IT
DID NOT DO ANYTHING, BECAUSE I CHECKED THE DATABASE AND FOUND OUT THAT
NOTHING WAS
UPLOADED.

PLEASE HELP HOW TO CALL OR RUN A DTS PACKAGE AS A VB MODULE IN THE VB PROJECT

Typing in all caps is considered screaming on newsgroups -
not sure if that's what you meant to do.
Please refer to the following article on executing a DTS
package from VB:
http://www.sqldts.com/default.aspx?208

-Sue

On Tue, 25 Apr 2006 06:29:02 -0700, TOM - BP
<TOMBP (AT) discussions (DOT) microsoft.com> wrote: