Deploy "Microsoft DTSPackage Object Library"?!

• WebTechie

  SSChampion

  Points: 11408

  More actions

  May 15, 2006 at 11:54 am

  #67487

  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

   

   

  Things will work out.  Get back up, change some parameters and recode.