Copying a file 1

[LonnieJohnson]

Can I copy a file on a network directory in SQL Server? I want to include it in a stored procedure.

Let me know.



ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[homebrew01]

What type of file ? You can use DTS to import text, csv ... type files directly into an SQL database

 

[LonnieJohnson]

Actually I was wanting it to be sort of a trigger type thing where it would copy a file from C drive to H drive.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[MaffewW]

both drives on the sql server? try this

xp_cmdshell 'copy c:\yourfile f:\yourfile'

Matt

Brighton, UK

 

[LonnieJohnson]

That's what I'm looking for!!!

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!