Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2011-12-20 : 09:17:10
|
| Hello All,I have to copy file daily from SQL job to the file server. The SQL job should create a folder first day of each month as 'Jan', 'Feb' etc.. and upload the file accordingly. If it's the last day of the month then it should create year folder '2012' and then month folder 'Jan' then copy the output of select table.How do I do this in xp_cmdshell? Can anyone give me a example or sample code?Thanks, |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Create folder and copy files using xp_cmdshell