I have a Stored proc which on execution, will generate data in the view .

My requirement is using SSIS, how can I create a Flat file pointing to this

Hi jaguarjags,

Just add a presumably an OLEDB data source pointing to the view and then connect it to a Flat File Source.

Hi MBH,

According to your description, you want to export the data returned by a stored procedure to a flat file.

After testing the issue in my environment, we can use Data Flow Task to achieve your requirement. For more details, please see:

1. Drag a Data Flow Task to Control Flow Task.
   
2. Create an OLE DB Connection Manager that connects to the corresponding server database.
   
3. Create a Flat File Connection Manager that connects to a new flat file.
   
4. Drag an OLE DB Source with the OLE DB Connection Manager already create, then change Data access mode to SQL command, type the query that execute the stored procedure in SQL command text.
   
5. Drag a Flat File Destination with the Flat File Connection Manager that connects to the Source component, then click Mapping pane to finish the mapping.
   
6. After execute the Data Flow Task or package, the flat file is created with the data returned by a stored procedure.

Thanks,
Katherine Xiong