March 6, 2003 at 5:17 pm
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
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