I needed to figure out how to have a spreadsheet perform a lot of data processing and then send the data to Sybase. It occurred to me to let DTS bring the data from Excel and then process the data.
- Vb6 Missing Microsoft Dts Package Object Library File
- Vb6 Missing Microsoft Dts Package Object Library Access
I found a link on the web that details how to have VB execute a DTS package.
![Vb6 Missing Microsoft Dts Package Object Library Vb6 Missing Microsoft Dts Package Object Library](/uploads/1/1/8/8/118839385/811368907.jpg)
![Library Library](/uploads/1/1/8/8/118839385/682841205.jpg)
I can create an Excel spreadsheet, create a button, attach the button to a macro and the macro will call DTS. Works great.
Help me run a DTS package with VB6. Or Microsoft DTS Custom Tasks Object Library (custtask.dll) with a late-bound call, which would work on your machine without an explicit reference being set. I am trying to use that module in a VB6 exe project with no success. When I try to run the project I receive a compile error, User-Defined type not defined, on the following line: Public goPackageOld As New DTS.Package I have added a reference to Microsoft DTS Custom Tasks Object Library. Are there other references I need to add?
Question:
Since I am a developer with SQL Server loaded as well as Microsoft Excel, I only had to select References and check the 'Microsoft DTSPackage Object Library'.
When I deploy this spreadsheet to the clients, they won't have SQL Server loaded. They might have just the Client connectivity loaded. How do I check for the instance of the object library? If it is not present, how do I load it (from somewhere) to insure that Excel can call DTS?
I apologize if I am in the wrong forum for this question.
Thanks.
Tony
Things will work out. Get back up, change some parameters and recode.
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.
|
|