I am doing some research to try to call a DTS package from
Visual Basic. What I have right now is a simple DTS package that exports a table to an Excel spreadsheet stored in the Local Packages of the database.
One path that I am exploring is calling the DTS through a ado connection. When building a connection string, the provider tab has two options with DTS: 1) Microsoft OLE DB Provider For DTS Packages and 2)SQL Server DTS FLAT File OLE DB Provider. Anybody know the distinction between the two? And which one would best enable the calling of a DTS Package?
I am open to other options to accomplish the task.
Thank you for any help that you may be able to provide.
Visual Basic. What I have right now is a simple DTS package that exports a table to an Excel spreadsheet stored in the Local Packages of the database.
One path that I am exploring is calling the DTS through a ado connection. When building a connection string, the provider tab has two options with DTS: 1) Microsoft OLE DB Provider For DTS Packages and 2)SQL Server DTS FLAT File OLE DB Provider. Anybody know the distinction between the two? And which one would best enable the calling of a DTS Package?
I am open to other options to accomplish the task.
Thank you for any help that you may be able to provide.
