Showing posts with label 1replicate. Show all posts
Showing posts with label 1replicate. Show all posts

Wednesday, March 7, 2012

DTS "execute on main package thread" issue

here is the error i get:

Microsoft Data Transformation Services (DTS) Package
0
(1:Replicate D318_DOCKET) SubStep 'DTSStep_DTSDataPumpTask_2' failed with the following error:
Provider generated code execution exception: EXCEPTION_ACCESS_VIOLATION

the package runs fine by itself from within Enterprise Manager but when i try to run the package from a Visual Basic project, i get this error. i tried to be careful to make sure i checked the "execute on main package thread" checkbox but it didnt make a difference...

has anyone seen this?I haven't seen it, but it looks like a permissioning problem. When you run the DTS package from VB are you running it with the same user details are when you run it from within Enterprise Manager?|||http://search.microsoft.com/search/results.aspx?na=84&st=a&View=msdn&qu=Provider+generated+code+execution+exception%3A+ EXCEPTION_ACCESS_VIOLATION&qp=&qa=&qn=&c=&s=4