Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 14th, 2006, 08:29 AM
Registered User
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to khanhmy264
Default Problem with DTS programming application

Hello everybody,

I'm a new commer. I'm happy to join dbForum with all of you. :D

I'm coding a DTS application for my company's data mart. And it's the first time I code a data movement application in .NET. I use SQL2000sp2 Personal Edition for datawarehouse and WinXPsp Professional.

I have looked around the site http://www.sqldts.com/default.aspx?225 and regst.txt in the SQL-CD to reference DTS.dlls as below:
INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)
---------------------------------------------------------
The following files must be registered using the regsvr32.exe utility:
dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll

Example: regsvr32 80\Tools\Binn\dtsffile.dll

The sqlunirl.dll file should reside in the system folder (i.e., \winnt\system32 or \windows\system).

I added other dll references successfully but sqlunirl.dll. And I recieve the err:
"C:\WINDOWS\system32\sqlunirl.dll" was loaded, but the DllRegisterServer entry point was not found. This file can not be registered." :(

As I run my application, it also fire an unhandled exception like this:
"Unable to cast COM object of type 'System.__ComObject' to Interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call the COM component for the Interface with IID
'{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed due to the following error: No such interface supported (Exception from HRESULT:0x80004002(E_NOINTERFACE))"

And here is the Err details:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
at DTS.Task.get_CustomTask()
at myDTSForNet.Form1.addDataPumpTask(String taskId, String taskName, String sql, String desTable) in E:\DATA\Kmy264\myDTSForNet\myDTSForNet\Form1.vb:li ne 81
at myDTSForNet.Form1.cmdDoDTS_Click(Object sender, EventArgs e) in E:\DATA\Kmy264\myDTSForNet\myDTSForNet\Form1.vb:li ne 26
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
myDTSForNet
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///E:/DATA/Kmy264/myDTSForNet/myDTSForNet/bin/Debug/myDTSForNet.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
Interop.DTS
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///E:/DATA/Kmy264/myDTSForNet/myDTSForNet/bin/Debug/Interop.DTS.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.



Please help me to solve the problem. Thanks alot.


best reguard, ^_^


khanhmy
:D:D:D
 
Old January 8th, 2007, 11:59 PM
Registered User
 
Join Date: Jan 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I know this is a rather late response. But wanted to help any one else there running into the same issue. I had exactly the same error message.
Resolved by applying SQL service pack to the CLIENT MACHINE.
I was using SQL server 200 and the server was already at sp4. However the SQL client components on the workstation did not have Sps applied. You can download the latest SQL service pack from microsoft download center. Worked like a charm for me. Good luck.
Bishop


 
Old July 3rd, 2007, 01:58 AM
Registered User
 
Join Date: Jun 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hari_vjti
Default

Hi Khanshmy, did you resolve that DTS error,
iam still struggling with that error at otask.CustomTask..

error given below..can you help me plz if you know.

"Unable to cast COM object of type 'System.__ComObject' to Interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call the COM component for the Interface with IID
'{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed due to the following error: No such interface supported (Exception from HRESULT:0x80004002(E_NOINTERFACE))"


Hi bishop as you said i installed Sp4 from microsoft website still iam getting same error, can you help me regarding this error.. i spend almost 5 days to resolving this bug.

thanX

hari

Hari
Sr Sw Engg
SAP India-Bangalore
 
Old May 20th, 2008, 04:50 AM
Registered User
 
Join Date: May 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I get exactly the same error..how did you resolve?






Similar Threads
Thread Thread Starter Forum Replies Last Post
dts problem garg SQL Server DTS 7 October 2nd, 2006 03:20 PM
Fax programming in Java application ramanadyv Java Basics 0 March 14th, 2006 03:18 AM
DTS Package with windows Application elghoul_girl C# 0 March 7th, 2006 06:45 AM
How to Incorporate DTS( SQL2k in Web Application Dilip Nagle General .NET 0 August 14th, 2005 11:23 PM
DTS Problem galaxy@net SQL Server DTS 0 January 7th, 2004 05:54 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.