| Author |
Topic |
|
hearnie
Starting Member
49 Posts |
 Posted - 2005-06-02 : 07:03:05
|
| Hi Guys,Can anyone help me here. I have a DTS package with an ActiveX script as a task, which copies a file from a share drive to a local folder. When I schedule the DTS package, each time it runs it fails to copy this file operates as if it doesnt exist. However if I right click the package and select Execute from within the Local Packages window.....it runs fine?anyone have any idea what this is?H. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-06-02 : 07:12:49
|
| DTS off the schedule...runs under the context (permissions, etc) of the server.DTS run from local package...runs under client context.are the shares/drive mappings the same?are the access rights the same? |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-06-02 : 07:31:25
|
| You will need to use the UNC path rather than a drive letter.You will need to make sure that the SQL Server agent service account has permission to access the share.-------Moo. :) |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
hearnie
Starting Member
49 Posts |
Posted - 2005-06-02 : 08:37:21
|
| I was just watchin the taskmanager while the task is running.If I run this manually it runs under my accountHowever dtsrun.exe which is running from the scheduler runs under the SYSTEM account.Is there a way to get dtsrun to run under my own account on the scheduler rather then the SYSTEM?H. |
|
|
|
hearnie
Starting Member
49 Posts |
Posted - 2005-06-02 : 08:47:33
|
quote:
Originally posted by Merkin
Dammit, another cross post.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50570hearnie, when you cross post, you waste the time of people that want to help you. It's rude. Don't do it.DamianIta erat quando hic adveni.
yeah sorry bout that but I found that I dont really know which category to post under half the time cos it is a developer issue but also DTS, anyhow I'll try limit it in future. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-02 : 08:53:45
|
| If you aren't sure, just pick one.Anyway, Control Panel -> Administrative Tools -> Services.Choose the account for the SQLSERVERAGENT service to run under.DamianIta erat quando hic adveni. |
|
|
|
hearnie
Starting Member
49 Posts |
Posted - 2005-06-02 : 09:05:48
|
| thanks Merkin,trouble is though there are a host of other databases on the same server, will this mean that all of the jobs assosiated with them will also get run under that accoutn that I setup? Would that affect those other jobs in anyway?Kind RegardsH. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-02 : 09:09:16
|
quote:
will this mean that all of the jobs assosiated with them will also get run under that accoutn that I setup?
yesquote:
Would that affect those other jobs in anyway?
Only you can answer that  The other thing you can do, is call dtsrun.exe from a windows scheduled job. You can set the user context for each individual job. Remember that mapped drives still aren't going to work, you'll need UNC paths \\server\share etcDamianIta erat quando hic adveni. |
|
|
|
hearnie
Starting Member
49 Posts |
Posted - 2005-06-02 : 09:13:59
|
| cheers for that....I cant answer if it would affect other database jobs as Im not the owner of those other DB's and so dont know what the jobs are set to do.....but my guess is it would.Gonna go with the batch file from a scheduler to run dtsrun under my account. Think thats the best option really, pain in the bhind though.thanks for the help.H. |
|
|
|
|
DTS fails to copy file when running on scheduler