Post reply

Need to import flat file that contains 708 fields

  • October 22, 2010 at 1:41 pm

    #242034

    Need to import a flat file that has a field count that exceeds allowable field count.

    Is there a way to import this with breaks creating multiple tables, AND generating a primary key to link them, all at the same time.

    <hr noshade size=1 width=250 color=#BBC8E5> Regards,Jeffery Williams http://www.linkedin.com/in/jwilliamsoh

  • October 22, 2010 at 1:48 pm

    #1241164

    Jeffery Williams (10/22/2010)

    Need to import a flat file that has a field count that exceeds allowable field count.

    Is there a way to import this with breaks creating multiple tables, AND generating a primary key to link them, all at the same time.

    What do you mean by "exceeds allowable field count"?

    SQL Server 2008 limits are:

    1,024 columns per nonwide table

    30,000 columns per wide table

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply