sql server dts: exceeding maximum columns -- sql server dts

exceeding maximum columns

Samuel
9/20/2004 10:42:34 AM

sql server dts: Hello,

I've this textfile with a column separator. When i import this textfile
there are over 1024 columns. Upon creating the table, i'm getting an message
that it is exceeding the maximum columns in sql server.

Now i probably need to transform the columns so that it can be normalized
into a table with less columns. How can i do this and is there an example
available.

Re: exceeding maximum columns

Allan Mitchell
9/20/2004 6:50:16 PM

[quoted text, click to view]

Can you not create the table up front insted of letting DTS do it for you? You
say that you want to play with the input anyway so does this bring it in under
the 1024 attribute limit?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know