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 22 (of 22 total)

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

Phil Parkin SSC Guru Points: 247180 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.

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: 247180 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.

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: 1004641 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.