Reading input file greater than max row size but creating multiple rows from input row.

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

Don't use a staging table, instead use SSIS to do the import and that way you can break down the records on the fly.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

SSIS will work, though it's more programming.

Are you using varchar(max) as the table field type?

Rossana A. Hnatyshyn SSC Rookie Points: 29 More actions · Answer 3

Yes I was going to use varchar.

The ultimate table will have a row size of 630 characters composed of many fields.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

I mean the staging table, varchar(max). Not just a varchar

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 5

I didn't think to ask that.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt