2nd post: DTS import won't let me import a large file...

#1

Hello, all. I'm trying to import a file into a SQL 2K
table. The record size is 4095 characters. For some
reason, when setting up my column positions (it's a fixed
length file), DTS won't let me go beyond the 4095th
column. My record size is 4221 characters.

Any help someone can offer is appreciated.
Thnx!
Roz

#2

You are trying to create 4095 columns in the text file ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Roz" <roshall (AT) nospam (DOT) swbell.net> wrote

Quote:

Hello, all. I'm trying to import a file into a SQL 2K
table. The record size is 4095 characters. For some
reason, when setting up my column positions (it's a fixed
length file), DTS won't let me go beyond the 4095th
column. My record size is 4221 characters.

Any help someone can offer is appreciated.
Thnx!
Roz

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2nd post: DTS import won't let me import a large file...

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

2nd post: DTS import won't let me import a large file... - 11-16-2003 , 08:10 PM

Re: 2nd post: DTS import won't let me import a large file... - 11-16-2003 , 08:52 PM