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