Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Upsert Dimension Table Expand / Collapse
Author
Message
Posted Saturday, November 25, 2006 11:55 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 26, 2014 12:56 AM
Points: 81, Visits: 190
Comments posted here are about the content posted at temp
Post #325468
Posted Tuesday, November 28, 2006 12:37 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 10:03 AM
Points: 577, Visits: 102
Is it just me, or is the article missing?

Signature is NULL
Post #325881
Posted Tuesday, November 28, 2006 1:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 8, 2006 12:13 AM
Points: 8, Visits: 1

Hi,

I urgently need to know how to carry out an UPSERT in SSIS 2005. If anyone knows the way to do it, please let me know as soon as possible.

TIA,

Uday.

Post #325888
Posted Tuesday, November 28, 2006 1:47 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 6:57 AM
Points: 568, Visits: 1,618
The article is printed in one of the fullstops via microfilm (lol)

-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible.
Post #325895
Posted Tuesday, November 28, 2006 1:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 8, 2006 12:13 AM
Points: 8, Visits: 1
Ok.... i havent the slightest idea what that meant!
Post #325898
Posted Tuesday, November 28, 2006 2:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:56 AM
Points: 6,748, Visits: 8,545

same player shoot again .... hit ball when lights are on

 



Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #325899
Posted Tuesday, November 28, 2006 3:07 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 10:03 AM
Points: 577, Visits: 102
Oh, upsert...thought this was the upskirt discussion.

But seriously, what's wrong with the following?

Update e
set ColumnName = i.ColumnName
from ImportTable i
JOIN TableName e on i.uniqueID = e.uniqueID


Insert TableName (ColumnName)
select i.ColumnName
from ImportTable i
LEFT JOIN TableName e on i.uniqueID = e.uniqueID
where e.uniqueID is null

Database 101, but is there some newfangled way to do this in the new Analytics? You'd still need to build the dimension and fact tables using SQL (or something), right?




Signature is NULL
Post #325915
Posted Tuesday, November 28, 2006 3:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 27, 2014 4:39 AM
Points: 6, Visits: 100

Delete from the target table where the same data exists in the source table.  At this point if the source row = target row its ok.  If source row has updated values you dont care either becuase the next step is to insert all source rows to the target which is essentially overwritting rows that have been updated within the source.

The easiest way of all however would be to use some kind of auditing within you loads from source to target.  But we dont live in a perfect world. 

If I could VPN to a client site I would add a sample package but again, we dont live in a perfect world!!!!!

Post #325923
Posted Tuesday, November 28, 2006 3:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 8, 2006 12:13 AM
Points: 8, Visits: 1
My question was not how do it in the DB directly. Im trying to figure out if there is a way in Sql Server Integration Services (DTS) to do the same using a transformation.
Post #325925
Posted Tuesday, November 28, 2006 3:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 20, 2012 12:20 AM
Points: 31, Visits: 44

Hi, use Lookup transformation on SSIS data flow page with the referential table. It is possible to update in standard output flow or insert in configured error flow.

Robert

Post #325930
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse