Post reply

Export MS SQL query to CSV file or FTP

  • December 1, 2011 at 9:54 am

    #247732

    Microsoft SQL server 2003

    I need to schedule a select query to capture some data and output results to a CSV file..

    Option 1:

    Run directly on the Server. Is this easy to do?

    Option 2:

    Use a window XP machine and utilize an ODBC connection? What do you suggest to use to accomplish this? I have experimented with winSQL, but looking for alternatives.

    Thank you for your time..

  • December 1, 2011 at 9:57 am

    #1415388

    Microsoft SQL server 2003

    Are you sure??? :w00t:

    Adding another option for your question. SSIS

  • December 1, 2011 at 10:02 am

    #1415394

    Is SSIS available on SQL 2003 server? Or is it DTS?

    I don't have access to the server directly (at least not yet), so I could not check.

    Thanks

  • December 1, 2011 at 10:11 am

    #1415404

    techzone12 (12/1/2011)

    Is SSIS available on SQL 2003 server? Or is it DTS?

    I don't have access to the server directly (at least not yet), so I could not check.

    Thanks

    I am really stumped. I know only these SQL Server versions (since SS2K for ease).

    SQL Server 2000

    SQL Server 2005

    SQL Server 2008

    SQL Azure

    SQL Server 2008 R2

    SQL Server 2012

    If it's a typo and you are talking about SS2K5, then yes. SSIS is available in SS2K5.

  • December 1, 2011 at 10:15 am

    #1415410

    Oops!. Sorry. You are right it is SQL 2005 running on Windows 2003 OS.

  • December 1, 2011 at 10:27 am

    #1415419

    Side question:

    Is is possible to export the query resutls to ftp site? If yes, then can you point me to a "tutorial or web-page" that explains how it's done on SQL 2005 server?

    Thanks

  • December 1, 2011 at 10:31 am

    #1415426

    FTP Task

    http://msdn.microsoft.com/en-us/library/ms137656(v=SQL.90).aspx

  • December 1, 2011 at 10:43 am

    #1415437

    Thank you. Truly appreciate it.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply