Post reply

Excel to Sql

  • March 6, 2003 at 5:17 pm

    #106197

    I have an issue running a DTS package through QA. The error is " Error string: Cannot update. Database or object is read-only. ". What the package does is first clear out a table then reimports data from an excel spreadsheet. I have tried to use xp_cmdshell with dtsrun, running the package through a stored procedure and by using OLE Automation.

    The same package with execute fine at the command prompt with dtsrun. Any help with this issue would be great

    Thanks Ken

  • March 10, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • March 10, 2003 at 3:37 pm

    #450741

    Check the permissions for the account running the package.

    When you run the package via xp_cmdshell and OLE Automation, the package is executing under the security context of the account the SQL service is running under. When you execute it from the command line it executes in security context of the machine where you have the command prompt open.

    Have a look a the following article for more info on security contexts applicable when running a DTS Pacakge,

    http://support.microsoft.com/default.aspx?scid=kb;en-us;269074

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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