When trying to create a text file using the DTS Designer,
I need to uncheck "FIRST ROW HAS COLUMN HEADER".

But the DTS designer fails to perform transformation as
it does not find column headers and if I click on "DEFINE
COLUMNS" under the Destination tab it completely blows up
the MMC and closes with an error :-(

Is this a know bug with DTS designer? If yes, are there
are patches for this?

The work around for creating a text file without header
column is to create a new DTS package every time and NOT
use DTS designer. But that's a lousy option since I have
to update my DTS packages quite frequently.

Any suggestions would be appreciated. Thanks.

In article <5f9e01c37d26$6172d250$a601280a (AT) phx (DOT) gbl>, Dhiraj Sharma
<dhiraj.sharma (AT) upbna (DOT) com> writes
The header not being skipped correctly is I think known behaviour, at
least have seen this plenty of times before, and workaround it by
creating a clean file for developing the package to start with. I
haven't had EM crash due to this problem myself. Make sure you have
applied the latest service pack to your client machine, as early on
there where some strange bugs in EM.

Also if you have applied SQL 2000 SP3 to your client you may want to
look at this issue-

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

This was originally only available as a hotfix direct from PSS, but as
per the KB article it has been included in the latest security patch
which saves you a PSS call, and also mean you are secure!

821277 - MS03-031:Security Patch for SQL Server 2000 Service Pack 3
http://support.microsoft.com/default.aspx?kbid

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

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

Darren,

The Security Patch 821277 - MS03-031: works great to fix EM error.

Thanks a bunch.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!