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

No comments:

Post a Comment