working with DTS package

[sachien]

Can anyone tell me how to work with DTS in VB 6.


And sample code or online link will do?

Please help

[jcis]

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.