thanks allan. i am not using visual basic. we have enough problems using dts
from within the designer. anyhoots, dts dies a stray dog's death in the
following case:

1. if you have service pack 3 installed on the sql server
2. and if you are using a text file with large number of columns.

i know this is retarded but I was dealing with a 883 column text file.

/*
karthik nagaraj
*/

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

In article <eCHwOn9PDHA.1552 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Karthik Nagaraj
<knagaraj (AT) dconx (DOT) com> writes
A 1000 column CSV loads fine for me, I was doing some testing recently
on the effects of a large number of columns. (SQL 2000 SP3)

Could you expand on what the package does and during what task does the
package fail.


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

That's quite puzzling. If you have an alternative email address, please let
me know. I can mail you the DTS file, a screen shot of the error and a
sample text file I am trying to load into sql server.

I was on the phone with microsoft and they sent me a hot fix that did not
work. They later said they'd have to open a separate case for the problem
and I'd have to pay for it. That was that. I haven't called them back.

K

"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:6FnKYvDrxfA$EwSN (AT) sqldts (DOT) com...