Running DTS packages thru VB 6
Posted on 2005-03-01
I have weekly raw data files that I run VBA macros on to format into .txt to ultimately upload to SQL Database. I have saved the DTS packages as .vbs files and appended the code to the correspoding formatting Modules in VB 6. When I execute the code, ultimately the code excutes but the package is not actioned - ie the data is does not upload.
The code is the standard DTS package created with the wizard when saved as a vb script (vbs) simply copied into a VB 6 module. I have changed the database connection to our production server and I would like to pass in the input file name from another subroutine.
How can I pump data (text files) into a SQL Database using VB/Excel?
Thanks in advance.