Please let me know how to create comma delimited file and
comma tab delimited file from database table. Which
components i should use in DTS.

Thanks

Have a look at these and you would simply do the reverse.

Importing A Text File Using The DTS Wizard
(http://www.sqldts.com/default.aspx?276)

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


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"va" <anonymous (AT) discussions (DOT) microsoft.com> wrote