Hello.

I have a VB 6.0 program that works with DTS packages.
I have SQL 2000 installed on my pc and the program runs correctly there.
The program has been copied to another pc where SQL 2000 is not installed
but I
copied all the required DLLs and Rlls and dtsrun.exe as described in an
article I found via Google called "Redistributing DTS With Your Program".

The program is failing on the pc where SQL 2000 is not installed on the
second line of code as follows:
Dim oDTS as DTS.Package2 --- No error
Set oDTS = New DTS.Package --- Here is where the program fails

Any suggestions will be greatly appreciated!

Thanks,
Rita

Have you checked that you have all the files as per redist.txt (as per Line
106) on the root of SQL 2000 Source CD / binaries ?

and then try and run RegSvr32 against the Dll's ie

REGSVR32 dtspkg.dll

cheers,
Andy.

"RitaG" <RitaG (AT) discussions (DOT) microsoft.com> wrote

To be honest it sounds like you have not got the DTS component installation
right. What is the error?

--
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com


"RitaG" wrote:

Hi Darren.

The error message I'm getting is
"Error Occurred in DTS: DropAndCReatePPOFOutTable.
ActiveX component can't create object."

Unfortunately it doesn't say which component is missing.

I tested the DTS package and it runs fine manually.

I then unregistered the DTS dlls that were included in my setup kit and then
registered them again and voila! - it worked!!!

Thanks for your interest.

Rita


"Darren Green" wrote:

Thanks Andy.
I unregistered the DTS dlls and reregistered them and then the program worked.

"Andy Ball" wrote: