dbTalk Databases Forums  

Exception_Access_Violation

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


Discuss Exception_Access_Violation in the microsoft.public.sqlserver.dts forum.



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

Default Exception_Access_Violation - 10-19-2004 , 06:34 AM






FYI, the problem was solved while i was writing the mail,

I am getting the following message when i execute DTS package which loads a
delimited text file into a table
"Provider generated Code execution exception: Exception_Access_Violation"

I created a template package with dynamic properties, I populate a global
variable with source filename, the package identifies a corresponding table
and dynamically maps and load the data. I created 7 packages for seven
different files, the packages are executed successfully when i run them
individually , i am calling all seven packages into another top level
package, when i execute a top level package one of the package is failing at
setting dynamic configs with message " Provider generated Code execution
exception: Exception_Access_Violation". I am starting all 7 packages at
once. I have been troble shooting with this for almost two hours.

While i am writing this mail I traid with serial execution , it worked. But
the message is scary, it is not informational to debug.



Thanks,
Subbu.





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.