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?