SQL Server Performance Forum – Threads Archive
SQL copy jobHi, Can I copy a file from one machine to another in the same network using SQL job? I have tried creating a job with "Operating SystemCommand (Cmd Exec)"
Command : copy D:Testabc.txt \IP est1 Regards
You can use this query EXEC master..xp_cmdshell ‘copy D:Testabc.txt \IP est1’ Madhivanan Failing to plan is Planning to fail
EXEC xp_cmdshell ‘copy c:sqldumpspubs.dmp \server2ackupssqldumps’,
yes offcourse xp_cmdshell ‘copy d: estabc.txt \ip est1’
Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami
Can do this from the DTS as well
but iam getting an error "Access denied"
Does the Microsoft SQL Server service account have the necessary permissions on the share (network permissions)?
It should be SQLAgent service account as it is used when you schedule the job, ensure this account has required privileges to copy the file. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.