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.

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?

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

Thanks.

Tony

Hello Webtechie,


Have a look at this article it may give you some ideas

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com