August 13, 2003 at 12:23 pm
I have written a stored procedure in SQL Server 7, and it is basically used for executing a DTS:
CREATE PROCEDURE [AgBurn_Update] AS
exec master.. xp_cmdshell 'dtsrun /S AQP-HQA1-NT-SRV /E /N AgBurn2_update'
---When I try to execute this stored procedure, I get the following error:
output
---------------------------------------------
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: Transfer SQL Server Objects
DTSRun OnError: Transfer SQL Server Objects, Error = -2147220413 (80040443)
Error string:
Error source:
Help file:
Help context: 0
Error Detail Records:
DTSRun OnFinish: Transfer SQL Server Objects
DTSRun: Package execution complete.
(12 row(s) affected)
---Does anyone have any idea as to what is causing the error and how to fix it assuming what I am trying to do is feasible? Thanks!
August 14, 2003 at 6:49 am
jlaz,
Are you by chance a administrator of the server?
BK
BK
August 14, 2003 at 9:44 am
I'm not the administrator, but I do have administrator rights to the server.
August 15, 2003 at 4:38 am
where are you transfering from?
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
August 15, 2003 at 9:45 am
I'm transferring data from another SQL Server that I do not have admin rights to.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply