Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Vincent Rainardi » Upsert Dimension Table
Add to briefcase
22 posts, Page 1 of 3
123»»»

Upsert Dimension Table Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
VincentRainardi
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: Monday, January 14, 2013 4:24 AM
Points: 81, Visits: 188
Comments posted here are about the content posted at temp
Post #325468
Calvin Lawson
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
uday balaji
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 08, 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
John McC
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: Thursday, February 21, 2013 6:30 AM
Points: 562, Visits: 1,404
The article is printed in one of the fullstops via microfilm (lol)

-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible.
Post #325895
uday balaji
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 08, 2006 12:13 AM
Points: 8, Visits: 1
Ok.... i havent the slightest idea what that meant!
Post #325898
ALZDBA
Posted Tuesday, November 28, 2006 2:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 2:13 PM
Points: 6,866, Visits: 8,071

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

 

Johan

     Jul 13

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
Calvin Lawson
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
Alan Hargreaves
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: Friday, April 05, 2013 6:01 AM
Points: 6, Visits: 43

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
uday balaji
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 08, 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
esbob cz
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
22 posts, Page 1 of 3
123»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.