October 23, 2003 at 5:06 am
I am using an Access XP project that uses DTS to load data into a SQL Server 2000 database. The DTS package is run from VBA code within the Access database. This works fine, however I want other users to use the database to import data.
I have used the SQL Server 2000 redist.txt file to identify the files i need to install on each users PC. The files are:
Data Transformation Services (DTS)
----------------------------------------------
File NameDescription
----------------------------------------------
sqlresld.dllSatellite Resource DLL Loader
dtsffile.dllDTS Flat File OLE DB Provider
dtsffile.rllDTS Resource File
dtspkg.dllDTS Package
dtspkg.rllDTS Resource File
dtspump.dllDTS Datapump
dtspump.rllDTS Resource File
axscphst.dllDTS ActiveX Script Host
axscphst.rllDTS Resource File
dtsrun.exeCommand Line Utility to Execute a DTS Package
dtsrun.rllDTS Resource File
sqlunirl.dllSQL Server Unicode/ANSI Translation Layer
custtask.dllDTS Custom Tasks File
custtask.rllDTS Custom Tasks Resource File
I used the Packaging wizard to install the files on the target PC but I am getting an error message of: "ActiveX component can't create object" when I try to run the import routine. The Access database compiles on the target machine without any errors.
Does anyone know what other files or actions are required?
October 23, 2003 at 6:24 am
October 23, 2003 at 10:35 am
Thanks for the help. I read the article and followed its instructions. I discovered that the Packaging Wizard doesn't seem to register the DLL's as I was still getting the same error message. I registered them using regsvr32.exe and it seems to work fine now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply