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 ««12

Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services Services Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 7:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:21 AM
Points: 293, Visits: 499
Andy,

I have a question about the operation and flow of records. Let's make the following change to your data.. Let's assume that the data coming in was using a super key (FirstName, LastName, Email). Then we write the data using only the PK E-Mail, but we grab all the records.

(Lets asume we had the following data already there.. Tim, Jones, tj@aol.com. : Now the data coming in.. (Tim, Jones, Timj@aol.com), (Tim, Jones, Jonest@aol.dom), (Tim, Jones, tj@aol.com)

I think the operation would be.. All records would go to the matching and then tj@aol.com would be dropped, since it matches. The others would update the existing record, so only the last write would exist in the database.

My test seems to prove this... just want to make sure my logic is correct.
Post #1424082
Posted Thursday, October 24, 2013 8:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 09, 2014 10:07 PM
Points: 3, Visits: 53
Yes, I know this is way old but I've used Stairway series before and so I'm just now going through this one as I learn SSIS for work...

First off, thanks for the great series! It's so easy to go through step-by-step and learn the concepts as you go!

Secondly, I am at the part where I'm trying to click the 'New' button next to the Name of the table or the view on the OLE DB Destination Editor window. The problem is, there is no New button! What's up with that?

Thanks and keep up the good work!

EDIT: Nm, I figured it out. I had forgotten to join the Conditional Split first. Ooops!

EDIT2: Sorry, but something I noticed is that even though I have the tasks in the correct order:

TRUNCATE
|
DATA FLOW
|
APPLY STAGED UPDATES

When I view the Progress tab after running it, it appears that Truncate is running last? I could verify this by checking the StageUpdates table after the initial run. It had no records. I assumed the order of task execution was determined by the visual design. What am I missing? thanks!
Post #1508314
Posted Thursday, March 20, 2014 6:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 3:54 AM
Points: 13, Visits: 3,522
I had been scratching my head over this for 2 days. For me it was char 56. Copying the string to Notepad and stripping out the spaces worked for me too. I had no idea hidden characters could be inserted in this way.
Post #1552977
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse