I would like to create ASCII format text file in DST. Is
there a way to do that?

What I want is to select some records from my table then
create text file (.txt) and save that file to Shared
Network Drive.

Is that possible? Thanks

Have you tried?
Have you looked at Designer?

If you reverse this process you won't go far wrong

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"hngo01" <hngo01 (AT) hotmail (DOT) com> wrote