Can anyone tell me how to work with DTS in VB 6.
And sample code or online link will do?
Please help
Printable View
Can anyone tell me how to work with DTS in VB 6.
And sample code or online link will do?
Please help
If you have MSSQL Server 2000, after you create your DTS pachage, you can save it as a VB module, after that you can add that module to your project.
You can edit your module if you want to make it por dynamic, for ex: the DTS package uses explicit server name, you can replace it with a variable containing the server name, this way things like that can be changed from your app.