How to send a file via FTP using SQL Server 2000 scheduled jobs?

I'm using SQL Server 2000 SP3, and I would like to schedule a job to send a text file via FTP.  Is this possible?  If so, how would I accomplish this?

I'd like to do so, without having to install any 3rd party add-ons, if possible.

Thanks!
jmchristyAsked:
Who is Participating?
 
jmoss111Commented:
I've built several sp's using info from Nigel's web site. works great:

http://www.nigelrivett.net/index.html#FTP

let me know if you need anything else.

best regards

jm

0
 
BlueYonderCommented:
Here is an example http://haacked.com/archive/2006/04/22/sqlcreateajobtobackupandftpyourdatabase.aspx.  Hopefully this is what you are looking for.  If not then you may have to use a data transformation service.
0
 
jmchristyAuthor Commented:
Yes, I found that on Google as well.  I read the comments on that and a few people were saying that they didn't have the stored procedure or that it didn't work.  I'll give it a try and see how it works.

Any other information is greatly appreciated.
0
 
jmchristyAuthor Commented:
Thanks for the link, contains the code I need to basically just copy/paste!  Being that I'm not a SQL guy by any means, this saves me a lot of time.

thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.