Can I export a query to text file?

I can't figure out how to make the destination. The data pump errors
because there is no transformation and there is no transformation
because the text file "connection" has no fields. Can you write a new
file or only append to an existing?

An odd lack of functionality!

thx
md

*** Sent via Developersdex http://www.developersdex.com ***

You can certainly export a query to text file. You must make sure that your
columns all have names though so

MAX(column Name) would not work but
MAX(column Name) as ColumnAlias would



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"M D" <mardukes (AT) aol (DOT) com> wrote

I managed to build one by hand, assembling a text-file-destination
connection, an oledb connection and a copy data task. It established
the file definition. The export data wizard, however, did not do the
job for the text file connection.

I guess I'm the first person to ever try it.

thx
md

*** Sent via Developersdex http://www.developersdex.com ***