i have a table called customer. I am trying to export the data in the table to text file. In DTS designer i have selected the server and text file and i have filled all required data. In transform task, in destination tab, clicked on define column button. its showed the columns in the table. clicked populate from source->execute. But it has populated in the destination tab. then if u click on define columns again, it has closed enterprise manager with out giving any record.

I have been facing this probelm from one month. If i do the same operation on my server itself, its working fine.

Not only for this table, we are facing the problem with many other tables.

Please help me.

It is a bug introduced by SP3

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



"Venkata Srinivasa Rao" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:A390DB33-664E-4896-B368-05C4F3C7933D (AT) microsoft (DOT) com...
and i have filled all required data. In transform task, in destination tab,
clicked on define column button. its showed the columns in the table.
clicked populate from source->execute. But it has populated in the
destination tab. then if u click on define columns again, it has closed
enterprise manager with out giving any record.

Dear sir,

Thank u for giving me a solution.

the given article explains the problem in SQL server (sp3).

In our environment we have two servers.

1. Development server (for development and R&D purpose) having (SP2)
2. Live server (Real server) having (sp3).

i am facing this problem in both servers on the same customer table. If it is only on live server (SP3) i can follow that referred article. But i am getting same prob in devpt server also.

Please help me.

srinivas

In article <92F2235C-15D5-4F4F-BC52-092CA4C9E832 (AT) microsoft (DOT) com>, Venkata
Srinivasa Rao <venkat.srinivas (AT) wepindia (DOT) com> writes
Where are you running Enterprise Manager? DTS is client side, so what SP
and fix have you got on the client?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org