Does Anyone know how you can copy values from a previous row into a null column in SSIS

Question

Does Anyone know how you can copy values from a previous row into a null column in SSIS

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

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

sgmunson SSC Guru Points: 110640 More actions · Answer 1

Jeff Moden - Wednesday, November 8, 2017 12:34 PM
sgmunson - Wednesday, November 8, 2017 6:43 AM
aaron.reese - Wednesday, November 8, 2017 4:09 AM
I would still prefer to connect to the source database and run the select statement behind the report rather than consume the report as a data source.
As would I... but you know how real life loves to throw curve-balls...
That's where bats, hammers, and high velocity pork chops become incredibly useful.

Not that a high velocity pork-chop wouldn't cause any pain, but it would have to move a lot faster than human hands can make happen to have as much impact as a similarly wielded bat or hammer.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 2

sgmunson - Thursday, November 9, 2017 1:22 PM
Not that a high velocity pork-chop wouldn't cause any pain, but it would have to move a lot faster than human hands can make happen to have as much impact as a similarly wielded bat or hammer.

That's just not a problem for me. 😉

--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)

aaron.reese SSChampion Points: 13498 More actions · Answer 3

Don't know why but that picture reminds me of the story of the RAF testing cockpits for bird-strike survivability by firing oven ready chickens at them. When the USAF tried it they had a 100% failure rate. Asking the RAF for advice, the reply came back

Try thawing them out first 🙂

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 4

aaron.reese - Friday, November 10, 2017 2:30 PM
Don't know why but that picture reminds me of the story of the RAF testing cockpits for bird-strike survivability by firing oven ready chickens at them. When the USAF tried it they had a 100% failure rate. Asking the RAF for advice, the reply came back
Try thawing them out first 🙂

I've heard that same story with many different countries but, no matter, it's still funny.

--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)

sgmunson SSC Guru Points: 110640 More actions · Answer 5

Jeff Moden - Friday, November 10, 2017 5:32 PM
aaron.reese - Friday, November 10, 2017 2:30 PM
Don't know why but that picture reminds me of the story of the RAF testing cockpits for bird-strike survivability by firing oven ready chickens at them. When the USAF tried it they had a 100% failure rate. Asking the RAF for advice, the reply came back
Try thawing them out first 🙂
I've heard that same story with many different countries but, no matter, it's still funny.

And in the case of the USA, it's actually true. Where on earth did you find that picture? That's just too precious. All I could think of, however, was the considerable odor of pig poo associated with firing anything out their backside. I couldn't quite stomach the idea of surgical implantation of a rocket... and seeing as that's the entire pig and not just a pork chop, that's a LOT more mass than a bat or a hammer, but I obviously get why you "don't worry about that".... BTW, where do I sign up for my own personal jet of this variety?

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

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

sgmunson - Tuesday, November 14, 2017 8:52 AM
Jeff Moden - Friday, November 10, 2017 5:32 PM
aaron.reese - Friday, November 10, 2017 2:30 PM
Don't know why but that picture reminds me of the story of the RAF testing cockpits for bird-strike survivability by firing oven ready chickens at them. When the USAF tried it they had a 100% failure rate. Asking the RAF for advice, the reply came back
Try thawing them out first 🙂
I've heard that same story with many different countries but, no matter, it's still funny.
And in the case of the USA, it's actually true. Where on earth did you find that picture? That's just too precious. All I could think of, however, was the considerable odor of pig poo associated with firing anything out their backside. I couldn't quite stomach the idea of surgical implantation of a rocket... and seeing as that's the entire pig and not just a pork chop, that's a LOT more mass than a bat or a hammer, but I obviously get why you "don't worry about that".... BTW, where do I sign up for my own personal jet of this variety?

IIRC, I was rummaging around for images associated with the phrase "When pigs fly".

--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)