I'm trying to copy the data from 1 file to another file.
When I create the task transform copy and specify the text
file name in the source tab and go to destination tab it
comes up with a dialog box which gives all the fields.
When I hit execute to define the same no. fields for the
destination it explodes (freezes and then sql server shuts
off). I have more than 170 fields in the file.

Works absolutely fine with text files that has below 50
fields.

Any suggestion. Please help.

In article <01ff01c340bf$1ac3b2f0$a301280a (AT) phx (DOT) gbl>, please help
<divyashruthi (AT) hotmail (DOT) com> writes
Sounds like it may be this if you are running SP3 on your machine-

814113 - FIX DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
http://support.microsoft.com/default...B;EN-US;814113

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