When creating a scheduled job is it possible to output the file to a shared drive on the network
When browsing for file location whien creating the job only local physical drives are shown and when inputting unc share the job fails
any ideas ?If you know the name/IP address of the network file then you can output the file by using:
\\servername\d$\data\filename.dat
where 'd$' is the drive you're writing to on that server.
(NB This doesn't work if you are doing any file handling using the Scripting Runtime DLL through T-SQL)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment