Post reply

SSIS to Query SQL server and save the query to CSV.. how to do it

  • May 20, 2015 at 12:18 am

    #304121

    Hi,

    I need to run a task where I need to eun a query and output it to CSV, for some reason, I manage to run the SQL task but how can I save it as a csv as a result file?

  • May 20, 2015 at 12:35 am

    #1799249

    Hi,

    Use OleDB source in your Data Flow task to get results and try using Flat File Destination for your output?

  • May 20, 2015 at 2:56 am

    #1799266

    Hi,

    Thanks for the reply and it seems to be simple, the problem is on my query, it has 3 temp tables that is created and it says "No column information is returned by the SQL command

  • May 20, 2015 at 3:27 am

    #1799269

    You should find answer to your problem under link below:

    http://www.sqldbpros.com/2011/12/ssis-no-column-information-was-returned-by-the-sql-command/[/url]

  • May 20, 2015 at 3:54 am

    #1799272

    Thanks, that do the trick and setting SET NOCOUNT ON / OFF around the store procedure fix some other issue. Many many thanks.:-D

Viewing 5 posts - 1 through 4 (of 4 total)

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