Post reply

Text file dump to network drive with DTS

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply