Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Importing text files via DTS with large record lengths

0 views
Skip to first unread message

BrendanDowns

unread,
Nov 24, 2009, 6:01:04 PM11/24/09
to
I am trying to import a fix length text file in database table using DTS
under SQL Enterprise Manger v8.0.
The text file has 360 fields and a total record length of 5500 characters.
The largest field is 100 characters.
There are also 1.1 million records in the file.

When trying to define field positions on the "Text File Properties / Fixed
Field Column Positions" screen I cannot define field positions past character
positoin 4096.
I have done other DTSs with 200+ fields and with a record length of < 4000
that work.

I am missing a configuration setting that allows record lengths of greater
than 4096?
Is this a feature of DTS?
Does this problem exist in more recent versions of SQL Enterprise Manager?

I am currently getting around the problem by making the file a Quote
Delimtied file, but this not the solution I want to run with.

Thanks

0 new messages