Executing dtsrun from a .cmd file
-
I have created a .cmd file to execute dtsrun from a ".cmd" file. The intent is to pass the password in as a parameter, so that the dts package can execute under a sql-server authenticated login with appropriate permissions.
When this job was scheduled and executed, it failed saying "user '\' not authorized. It seemed to not "see" the parameter (a file name) that was passed in the dtsrun command.
Has anyone else tried this and how did you get the job to run in the appropriate security context?
Sheri
-
Sheri
Maybe you could post the batch file so we can look at it.
Generally, when I'm running scheduled DTS packages they are run in the security context of the SQL Agent account.
If I need to have the package run manually, I still setup the scheduled job, but I don't give it a schedule. Then I run sp_start_job to run the job. This way they still run in the security context of the SQL Agent account.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply