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 SSISI 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.