dbTalk Databases Forums  

SQL Server 200 DTS package VB.Net Random Error. Package works sometimes?

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


Discuss SQL Server 200 DTS package VB.Net Random Error. Package works sometimes? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rog
 
Posts: n/a

Default SQL Server 200 DTS package VB.Net Random Error. Package works sometimes? - 07-12-2006 , 07:58 AM






All,

I have a SQL Server dts package that I converted several months ago.
The program basically takes paradox tables and moves them into a SQL
Server database. Some of the files are maybe 10 MB.

It runs fine for several of the files, but randomly I get an error on
this statement.

goPackage = New DTS.Package

The error I get is Untrapable Error on this statement.

Inside the ExecutePackageCall.

The funny thing is I run the program and it executes this statement say
100 times once, then say only 15 the next time I run it. I do have a
Try catch around this statement, so I really don't understand the
"Untrapable Error".

Any suggestions would be appreciated.

Thanks,

Rog


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.