T
TOM - BP
I CREATED A SIMPLE DTS PACKAGE TO UPLOAD AN EXCEL FILE INTO A TABLE IN SQL
SERVER DATABASE THEN SAVED THIS PACKAGE AS A VISUAL BASIC MODULE FILE. THEN 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 DO ANYTHING, BECAUSE CHECH 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
SERVER DATABASE THEN SAVED THIS PACKAGE AS A VISUAL BASIC MODULE FILE. THEN 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 DO ANYTHING, BECAUSE CHECH 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