Hi
I have set-up a DTS local package which, if executed, runs ok
there is a job that runs based on the DTS
Operating System Command (cmdExec)
DTSRun /~Z0x2D35A89DED3951A08C911FB002FDF25EDBB091C51DC3365B34576901DC31D6E7E6F622FDA3A21AA76C76863501518421D37D6F66D9249AAC4678639082BDB30645AE282D24BA71DC4FC5BE7D4E2F3D0FAE523C6B644912081F9BD56FC9DE677A50550C8F8C637DCDC3F97921ED79523C7D8339761B5E0B8EFD09C8D93B1D40F26F567457E45BE13145B28E70B78D67F6D4AB52EA8C8522171472E0
this fails ?
I have run the job as owner sa, which exists on both SQL servers and has sysadmin rights ?
any ideas ?
regards
cath
I have set-up a DTS local package which, if executed, runs ok
there is a job that runs based on the DTS
Operating System Command (cmdExec)
DTSRun /~Z0x2D35A89DED3951A08C911FB002FDF25EDBB091C51DC3365B34576901DC31D6E7E6F622FDA3A21AA76C76863501518421D37D6F66D9249AAC4678639082BDB30645AE282D24BA71DC4FC5BE7D4E2F3D0FAE523C6B644912081F9BD56FC9DE677A50550C8F8C637DCDC3F97921ED79523C7D8339761B5E0B8EFD09C8D93B1D40F26F567457E45BE13145B28E70B78D67F6D4AB52EA8C8522171472E0
this fails ?
I have run the job as owner sa, which exists on both SQL servers and has sysadmin rights ?
any ideas ?
regards
cath