Access required to execute a DTS package

[JtheRipper]

Hi there,

I want to use the dtsrun utility to execute a package on a server. The package does a copy of SQL Server objects from one database to another.

When I logon to the server as the administrator, the dtsrun utility executes fine, but as soon as I log on to the server as a normal user the package fails with:

C:\WINNT\system32>dtsrun /Stestsrv3 /U<username> /P<Pwd> /N&quot;Copy Jaco to Jaco1_bk /R
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSTransferObjectsTask_1
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting objects for Transfer; PercentCompl
e = 0; ProgressCount = 0
DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147024891 (80070005)
Error string: Access is denied.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error Detail Records:

Error: -2147024891 (80070005); Provider Error: 0 (0)
Error string: Access is denied.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100


Error: -2147024891 (80070005); Provider Error: 0 (0)
Error string: Access is denied.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 5700


Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [SQL-DMO]CreateFile error on 'TESTSRV3.Jaco.LOG'. Access is denied.

Error source: Microsoft SQL-DMO
Help file: SQLDMO80.hlp
Help context: 1132

DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1
DTSRun: Package execution complete.
c:\temp\mydts.bat exited on testsrv3 with error code 1.

I created a user in SQL Server with privileges to execute the package, I do not know what the user I logged on to the OS has anything to do with it.

I am sure I am not the only person trying to do this, and it is silly that this can only be done if the user is part of the administrators group.

Can anyone pls help me!
Thanks,
Jaco