SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard billy_111's Avatar
    Join Date
    Jul 2009
    Posts
    1,683
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Upload SQL XML file to FTP

    Hello,

    I had a question about uploading an XML file generated by a SQL server statement to an FTP account.

    For example, i have put together a stored procedure that runs a SQL statement and writes to a file that runs each day as a Schedule Job using SQL Server Agent.

    Now the last thing i need to do is to be able to upload the outputted file to an FTP account but i'm not entirely sure how to go about doing this. I have looked into Windows scheduler and also Command Line tools but would prefer asking the professionals

    Any ideas anyone?

    Kind regards,
    Software Engineer ASP, ASP.NET, VB, PHP

    Kind regards
    Billy

  2. #2
    Non-Member
    Join Date
    Apr 2004
    Location
    Miami, FL, USA
    Posts
    449
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Not really a DB question. Probably best asked in a Microsoft-specific forum if you're looking for a tool that will automate the task for you. Have you tried http://forums.asp.net/ ?

  3. #3
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,629
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Easiest way would be to execute a command line from the scheduled task. Windows has a FTP client built in (ftp.exe) that can take command files to allow for reasonably complex scenarios such as this.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •