How to create MS SQL2005 job/stored Procedure to copy files across

[DannyPole]

Good people.
I have a situation here.
i have to copy csv file from a PC in another domain to a PC sitting on another Domain. The firewall has been opened and ip address given.
I am more from the front-end and not a specialist with jobs and stored procedure.
Can someone please help me. One can reply here directly and cc me on pole@labware.com

 

[hmckillop]

Hello

yes I can help 100% - dont do this as a SQL job or stored proc. This is scheduling/operating system job. You could do this in many ways, e.g. create a batch file

COPY \\sourcemachine\myshare\files.* \\targetmachine\targetfolder\
[schedulefile.bat]
[\code]

Then create a windows scheduled task to run it however often you want. 

Definitely not a SQL problem (though you could do it), but there are 100 and 1 ways to do this and much simplier than using SQL.

Hope this helps.



"I'm living so far beyond my income that we may almost be said to be living apart