Post reply

Getting EXCEPTION_ACCESS_VIOLATION while trying to open DTS Package in designer mode.

  • June 6, 2008 at 7:23 am

    #71433

    Hello,

    I am trying to open a DTS package in design mode. It is giving me the following error as a pop - up

    Error Source: Microsoft Data Transformation Services (DTS) Package

    Error Description: Code execution exception: EXCEPTION_ACCESS_VIOLATION

    when I click OK, I get the following message pop up,

    The selected package cannot be opened. The DTS Designer has been closed.

    Is there anyway to open the package in designer mode? The package tasks are as follows:

    Step1: write to a text file.

    Step2: Read from the text file and invoke Soap for a web service and write the results to a text file.

    Step3: Update database table using Data Driven Query Task. This task reads from the above text file created in step 2 and updates the table.

    Step4: Export the results to a csv file.

    Any help in this matter would be greatly appreciated.

    Thanks,

    Kesav

  • June 18, 2008 at 11:59 am

    #830673

    I did not close the file handlers properly and did not dispose the SOAP object properly. This caused the error I suppose. Again did it from scratch keeping in mind the above mentioned issues and it still works.

    Kesav

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply