Post reply

Dts-import fails -Exception access violation

  • August 25, 2004 at 11:00 am

    #65680

    Hi,

     

    I am trying to import .csv files into SQL2k-sp3 database.It's failing with the following error

     

    Need to run the object to perform this operation.

    provider generated code execution exception:Exception_Access_Violation.

     

    Any help is highly appreciated.

    Thanks,

    MK

     

  • August 26, 2004 at 3:32 am

    #520662

    If you are running the DTS package as a job, your SQL agent needs access to the operating system file. That means your sql agent must be started with windows authentication.

    5ilverFox
    Consulting DBA / Developer
    South Africa

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

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