Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Use SSIS to execute a query and generate text file

Author  Topic 

Starting Member

1 Post

Posted - 2015-03-31 : 11:58:21
How do I use SSIS to execute a query and put the query results in a tab delimited text file?

Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-31 : 12:15:28
dataflow task

input:oledb or odbc or runs the query
output: flat file, tab-delimited text.
Go to Top of Page

- Advertisement -