Missing Last Row of Data

Question

Missing Last Row of Data

Viewing 6 posts - 16 through 20 (of 20 total)

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

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 1

I don't know SSIS but "ragged right" strongly suggests missing columns. You don't have missing columns so turn off "ragged right".

Are you absolutely sure the last row has the linefeed character?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 2

Jeff,

I'm not sure of the intention of ragged right, but I know for a fact in SSIS 2005 it was just about the only version of Flat File Connection Managers that ever worked correctly, and worked no matter if the file was delimited or fixed width.

Delimited worked occasionally. I was never able to get fixed width to work correctly, no matter how good my data was.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

michael.french 172 Default port Points: 1472 More actions · Answer 3

Apparently I am hitting a known bug that is fixed in SQL 2008R2 SP1.

I am testing right now and I will report back when I am confident of the solution.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 4

michael.french 172 (11/17/2011)
Apparently I am hitting a known bug that is fixed in SQL 2008R2 SP1.
I am testing right now and I will report back when I am confident of the solution.

Ahha! That explains a few things.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 5

Brandie Tarvin (11/17/2011)
Jeff,
I'm not sure of the intention of ragged right, but I know for a fact in SSIS 2005 it was just about the only version of Flat File Connection Managers that ever worked correctly, and worked no matter if the file was delimited or fixed width.
Delimited worked occasionally. I was never able to get fixed width to work correctly, no matter how good my data was.

I'm still using 2k5 SSIS (nowhere I've worked has upgraded the SSIS components) and use delimited constantly. Rarely if ever have a problem. I avoid Ragged Right simple because my end users know better then to put our spacers into text fields (pipes, etc), but they're more then happy to hit enter a few times. XD

Yes, I know, quote delimited etc etc, but I've just never really ran into the level of difficulty you're describing Brandie.

Michael: Nice find on the bug. Good luck! Can you pop up a link to the bug details you found?

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 6

Brandie Tarvin (11/17/2011)
Jeff,
I'm not sure of the intention of ragged right, but I know for a fact in SSIS 2005 it was just about the only version of Flat File Connection Managers that ever worked correctly, and worked no matter if the file was delimited or fixed width.
Delimited worked occasionally. I was never able to get fixed width to work correctly, no matter how good my data was.

You've given me even more reason to not use SSIS. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)