Any programmers out there have ideas on where or how can i install the DTS library into my visual basic? How to install MICROSOFT DTSObject Library. However I do not have Microsoft DTSPackage Object Library in my Visual Basic's reference file. Place the sqlwoa.dll and sqlwid.dll files in the system folder. The following is a list of redistributable files for DMO sqldmo.dll sqldmo.rll sqlresld.dll sqlsvc.dll sqlsvc.rll sqlwoa.dll sqlwid.dll for DTS Components: Sqlresld.dll Dtsffile.dll Dtsffile.rll Dtspkg.dll Dtspkg.rll DtsPump.dll DtsPump.rll Axscphst.dll Axscphst.rll Dtsrun.exe Dtsrun.rll Sqlwoa.dll Sqlwid.dll Register the dtsffile.dll, dtspkg.dll, dtspump.dll and axscphst.dll.
OK, do this: When you do the setup, you need to include this list of dependancy files in order for DTS to work on a client after your install. Yes I used Visual Studio Installer to package. Step failed Microsoft OLE DB Provider for SQL Server SQL Server does not exist or access denied. The error is: Copy Data from MODULE_NAME to.
The code was generated by DTS in SQL Server, i m transfering from Access to SQL Server.
