CODEWITHSUNDEEP
sqlsql-serversql-server-2008ssis
Deepak Nellurvalappil
Deepak Nellurvalappil

Reputation: 71

how to write the output of an execute SQL task in to a flat file SSIS 2008

I have created an SSIS package which includes an Execute SQL Task which executes the DBCC checkdb. Now , I want to write the output of this task into a flat file.

I tried my best but couldnt find any way to collect the output of the executed task or any means to move the output of a task in control flow to the data flow task.

Thanks in advance.

Upvotes: 0

Views: 13069

Answers (1)

Stagg
Stagg

Reputation: 2855

You need to use the Data Flow task instead of an Execute SQL task. In the Data Flow Task setup a Source OLE DB component connected to your Flat File destination component. The source OLE DB component will contain the same query as your Execute SQL query.

Upvotes: 2

Related Questions