Deploy "Microsoft DTSPackage Object Library"?!

W

Webtechie

Hello,
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
Microsot SQL Server DTS bring the data from Excel and then process the data.

I found a link on the web that details how to have VB execute a DTS package.

http://www.sqldts.com/default.aspx?208

I can create an Excel spreadsheet, create a button, attach the button to a
macro and the macro will call DTS. Works great.

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? How do you
check for the existence and/or load it via code.

I apologize if I am in the wrong forum for this question.

Thanks.

Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top