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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS Pack saved as VB module and need to execute

Author  Topic  msb_s Starting Member 4 Posts Posted - 2002-08-26 : 08:28:58 I have created a DTS Package for exporting the contents of an EXCEL 2000 file into a Table in SQL 2000 Server. WHen i execute the DTS Pack then the data is properly getting exported into database. Also i have saved that DTS Package in VB as "DTSPack" and the file is named and stored as "DTSPack.bas" file Now i would like to execute that "DTSPack.bas" file from a VB exe . So i cerated a new project VB standard exe project and then i included the "DTSPack.bas" file into Project. Then I called that "Main()" function of "DTSPack.bas" file. I am not getting any error but nothing seems to be happening. Actually what should happend is that "DTSPack.bas" is inteneded to export the content of an EXCEL file into DB table but it doesn't seem to be happening Please help regarding this Thanks in advance sai