Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    33

    Unanswered: 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?

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    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?

  3. #3
    Join Date
    Jan 2004
    Posts
    49

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •