How to make a results to file from SSIS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to make a results to file from SSIS

I know I have done this before.. u know the feeling… but I cant recall.. I have a script that will create a bunch of commands. you could run this query, copy all the results (results to text) and paste it to a new window and run it. but I want to use SSIS to put the results into a file then run the file (which will read just like a sql script) and run it through the file connection of the sql task. when I try a transform it said there are no column names in the output and wont go further. I dont want to have column names… thoughts?
got it..never mind.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |