dbTalk Databases Forums  

DTS COM Callable Object Problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS COM Callable Object Problem in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
-=JLK=-
 
Posts: n/a

Default DTS COM Callable Object Problem - 09-17-2004 , 02:49 PM






All,

I have a vb.net library object that was created with a COM Callable
Wrapper. This object is working great and I can call it from an Active X
script in DTS without any problems and it works perfect. The problem begins
when I make the call inside the Transform Row of a Data Transformation the
system locks up. It appears that about 1000 records are processed (not
committed) and then the system seizes. Has anyone else experienced anything
similiar. I can call the COM object several thousand times in a loop in an
Active X script outside the Data Transformation taks without trouble.

TIA,

James K.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.