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

Question

Post reply

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

Jim5130

Mr or Mrs. 500

Points: 589
More actions
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?

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

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

Emil B SSCertifiable Points: 5659 More actions · Answer 1

Hi,

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

Jim5130 Mr or Mrs. 500 Points: 589 More actions · Answer 2

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

Emil B SSCertifiable Points: 5659 More actions · Answer 3

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/%5B/url%5D

Jim5130 Mr or Mrs. 500 Points: 589 More actions · Answer 4

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