Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
troyerox
Starting Member
2 Posts |
 Posted - 2010-09-16 : 10:57:18
|
| I have created a DTS process to bring tables from an MS Access database into a SQL2000 database. It will run fine when I run it from DTS but when I set it up to run from a sql stored procedure I get the following error: DTSRun OnError: Copy Data from Patient Table to [Reports].[dbo].[EZclaimPatientTable] Step, Error = -2147467259 (80004005) The funny thing is that it ran fine through sql until about a month ago when the agency switched domain servers to a SQL2008 server but the database server is still sql2000.It must be a permission issue?Thanks Roxanne |
|
|
|
|
|
DTSRun OnError Stsep, Error = -2147467259 (8000100