SQL Server Performance

How to make a results to file from SSIS

Discussion in 'SQL Server 2005 General Developer Questions' started by MichaelB, Jan 4, 2012.

  1. MichaelB Member

    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?
  2. MichaelB Member

    got it..never mind.

Share This Page