loading data from staging table to final with validations to data specific

Question

loading data from staging table to final with validations to data specific

Viewing 7 posts - 16 through 21 (of 21 total)

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

Phil Parkin SSC Guru Points: 246985 More actions · Answer 1

For those who enjoy the additional challenge of working on the same question in multiple parallel threads, this question is also posed here.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

asita SSCarpal Tunnel Points: 4144 More actions · Answer 2

this is the new post can you please help with it if possible

Thank you

ASita

Phil Parkin SSC Guru Points: 246985 More actions · Answer 3

asita wrote:

this is the new post can you please help with it if possible
Thank you
ASita

As you are looking for a SQL Server solution, rather than SSIS, Jeff's solution is worth checking out. He knows more about importing data direct into SQL Server than anyone else I can think of.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

asita SSCarpal Tunnel Points: 4144 More actions · Answer 4

Hello Jeff,

Can you please help with it in the way you advised in SQL SERVER.

https://www.sqlservercentral.com/forums/topic/how-to-insert-data-to-target-table-when-there-is-no-matching-and-update-if-has#post-3888376

Thank you

ASiti

asita SSCarpal Tunnel Points: 4144 More actions · Answer 5

asita

SSCarpal Tunnel

Points: 4144

May 26, 2021 at 7:39 pm

#3888378

Thank you Much Phil.

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

asita wrote:

Hello Jeff,
Can you please help with it in the way you advised in SQL SERVER.
https://www.sqlservercentral.com/forums/topic/how-to-insert-data-to-target-table-when-there-is-no-matching-and-update-if-has#post-3888376
Thank you
ASiti

Sorry... I kind of ignored this thread because it looked like folks had handled it with SSIS. Do you actually need a non-SSIS solution? If so, can you provide the CREATE TABLE statement for your target table that "has about 50 columns in it", please? 😀 Or do you want everything loaded into character based columns?

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

asita SSCarpal Tunnel Points: 4144 More actions · Answer 7

Sure Jeff. Will provide shortly, I am preparing it. Thank you in advance.