I have got it to work.

No problems here. It sounds like you don't have the right componet
installed. You need to install the SQL Client on the computer you are trying
this on.

Shawn Regan
Applications Developer
Pacific Technology Solutions 

-----Original Message-----
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 3:22 PM
To: CF-Talk
Subject: DTS via OLE


Has anybody tried invoking DTS packages using OLE as shown in the article on
Swynk <http://www.swynk.com/friends/green/dtsole.asp>? I've got the
following
error:

***  Create Package object failed
OLE Automation Error Information
  HRESULT: 0x800401f3
  Source: ODSOLE Extended Procedure
  Description:  Invalid class string

This happens when it tries to create the DTS object. Is this maybe for a
different version on SQL Server? I'm using 7 right now...

David Cummins
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to