I am trying to export data from SQL server to a text file
with a certain format.

The issues are
1. DTS design view does not allow me to insert columns
manually. The list of columns can only populated from
source. While I only need to populate certain fields in
the targeted file format.

2. Now I first create a dummy query just in order to
populate the target columns. The format has about 40
collumns. Problem comes as when I hit "execute" button to
save the list, all columns dispear. When I click "Define
Column" botton, Management Consule crashed. 100%
duplicable. I played around and found that if I change
the column names to short ones. It can be saved. But
whoever wants to have "a", "b" ... as column names? It
would be a maintainance nightmare later on.

Any one had the similiar problem?

You may be experiencing this problem then.

http://support.microsoft.com/default...B;EN-US;814113


--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"W.Gao" <Wanjungao (AT) yahoo (DOT) com> wrote