Text file dump to network drive with DTS

• Jason Marshall

  SSCommitted

  Points: 1791

  More actions

  September 13, 2006 at 3:02 pm

  #71020

  Hello-

  I'm creating a DTS package to dump the results of some stored procs to text files.  I am using the text file destination connection objects in the DTS designer.  When I make the transfornation from the data source to the text file object, I type in the SQL query to run, and then go to the Destinations tab.  Most of the transformations were created with no problems, but for some, when I click 'Execute' on the Destinations tab, it comes up blank instead of populated with the destination column names...

   

  Has anyone run into this?

  Thanks in advance-

  Jason

• Sreejith Sreedharan

  SSCertifiable

  Points: 5403

  More actions

  September 13, 2006 at 3:43 pm

  #660261

  After you are done with setting the tranformation, run the DTS. Just by setting the tranformation does not output the result(and the Column Name) to the text file. Hope this helps

  Thanks

  Sreejith