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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:05 PM
Points: 321, Visits: 571
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: Monday, August 25, 2014 10:47 PM
Points: 3, Visits: 57
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 8, 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
Posted Friday, May 9, 2014 1:57 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:05 PM
Points: 321, Visits: 571
Hey Andy.. When you are working on the OLE DB Destination, why would I get the error "No column information was returned"?

I have the update statement, just like the one I did for this training.. If I put it into SSMS and replace the question marks, it updates the table just fine.

I looked at the data flow path editor and it shows all the columns from the table read, and the column added from the lookup (PK for the table to write to).
Post #1569441
Posted Thursday, May 15, 2014 9:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:21 AM
Points: 2, Visits: 16
Hello Andy,
Thank you for a great series and explanations with the figures.
Very straight forward.

My current issue is that I can't not get the parameters shown when I am setting up on the OLE DB Command. I tried using the update * set * = ? and I don't see the parameters list available. like Param_0, Param_1

Is there a way to manually setup the parameters or do you happen to know why they do not show up?
Post #1571372
Posted Tuesday, May 27, 2014 8:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:21 AM
Points: 2, Visits: 16
I finally got it to work. I was having issue with the data type and also the order of the parameters selected had to match what I was having modified into the database.

Thanks again for the wonderful guide lines.
Post #1574795
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse