Create a Visual Basic application that executes a DTS package. Start the Visual Basic development environment, and then create a new Windows application (Standard EXE). On the Project menu, click References. Click to select Microsoft DTSPackage Object Library, and then click OK. Add a new command button to the form. It will have the default.

Hi all, I have installed a system over one server and three clients. One part of this is activating a DTS on the SQL Server on the server computer. This works fine for two of the computers but one of them brings up an error: 'ACTIVEX COMPONENT CANNOT CREATE OBJECT 'RUNTIME ERROR' 429.' I think it might be something to do with the OS, the troublesome client is running XP. Or is this a.DLL or an.OCX problem? Any help is greatly appreciated.

RE: ActiveX problem (TechnicalUser) 7 Jul 05 10:01. Hi, I think your right that it is a DLL or OCX file.

Download sequences for the klub 11. However on mahine its installed on I ran MDAC_TYP.exe, problem might be that client has XP SP2 - not too sure if MDAC works on SP2. I have posted my code below: Public Sub btnTransfer_Click() Dim oPkg As New DTS.Package2 oPkg.LoadFromSQLServer 'SIMATIC WINCC',,, DTSSQLStgFlag_UseTrustedConnection,,,, 'Data Transfer' oPkg.FailOnError = True oPkg.Execute oPkg.UnInitialize If oPkg.FailOnError = True Then MsgBox 'Transfer Was Completed' End If End Sub Although I think the code is sound as it runs on all other clients.

Thank you for the help. RE: ActiveX problem (TechnicalUser) 8 Jul 05 09:52. The DTS.Package2 object comes from the Microsoft DTSPackage Object Library, which you have referenced in your VB project. The.dll for this reference is dtspkg.dll, which on my machine resides at C: Program Files Microsoft SQL Server 80 Tools Binn. As far as MDAC goes, you shouldn't have to run MDAC_Typ on WinXP, as ADO 2.8 is already installed in XP.

The SP2 shouldn't be a problem.I develop apps on XP SP2 using ADO and have had no problems. Look into the dtspkg.dll. You can either copy it from yopu dev machine to the client and register it with Regsvr32, or you can install the SQL Server client tools, which will install thi dll as well. Let me know if this helps.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky.

- Homer Simpson RE: ActiveX problem (TechnicalUser). Ive noticed I get a problem when I try to register anything of the DTS dll files. Is there a special library folder or something Im missing, maybe somewhere I can download an MDAC type program that installs the DTS files. This problem has been driving me nuts for months!!!! Its just trying to call a DTS action from a client. I set it up on one client.

It however had a copy of SQL Server on it. I simply created the DTS action on the local machine (still transfering data from server) and this works. The other clients do not have SQL Server on them. RE: ActiveX problem (Programmer) 12 Sep 05 10:31.

NOTE: If you do not have a reference for the Microsoft DTSPackage Object Library, use Explorer to locate the Dtspkg.dll file. Dtspkg.dll is typically located in the Binn folder. After you locate the file, you can manually register the Dtspkg.dll file by using Regsvr32.exe. The following example shows how you can run this utility from a command prompt in the same folder as the Dtspkg.dll file: REGSVR32 dtspkg The message you receive is DLLRegisterServer in dtspkg completed. If Dtspkg.dll is not found, SQL Server may not be installed correctly. See SQL Server Books Online for more information. -George Strong and bitter words indicate a weak cause.

- Fortune cookie wisdom RE: ActiveX problem (TechnicalUser). When you insert the SQL Server disc and the installer runs, you should get an option to choose what you want to install. When it runs, select SQL Server 2000 Components, then Install Database Server, then hit Next until you get the dialog titled Installation Selection.

There you select 'Create a new instance of SQL Server, or install Client Tools'; make sure that option is selected and click Next a few more times. When you get to a screen called Installation Definition, select the option for Client Tools Only - this should install the libraries that you need. I used to rock and roll every night and party every day. Then it was every other day.

Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson.

Many thanks for replying John.can i trouble you for more help. I have copied the required files to the client machine and it has recognised the code however i am now experiencing a different problem in my code at loading point: oPKG.LoadFromSQLServer sServer, sUsername, sPassword, _ DTSSQLStgFlag_Default,,,, sPackageName The error that i get is 'Invalid class string' and then when i debug and hit f8 i get 'Step 'DTSStep_DTSDataPumpTask_1' already exists in the collection.' I have changed the name of the package and i get a unrecgnised package error which proves that at least it is checking the SQL Server and did not find the name.i have also tried to find any help but nothing.can u advise wat i should d next it is confusing the hell out of me.i can abort the DTS routine alltogether and import it via access and update a likn table, but i would much rather solve this and know that i can run a DTS package Many Thanks In Advance ASH. > The SQL DMO libraries (there are several) are installed and registered when > you install the SQL Server client utilities. Just install SQL Server as > usual but select Client Utilities from the options screen. > Alternatively you can copy and register the libraries manually but it's a > little complicated. See > 'Enabling SQL DMO Clients Without Installing the Client Side Utilities > (Q248241)' > > Can anyone help me i have Access 2k and Vb Studio installed on my machine.