April 19, 2011 at 3:56 pm
My package currently, can connect to Salesforce and get any new or changed record from a certain date, this then inserts the record into a table. What I am having trouble doing is figuring out how to Update the record if it already exists or Insert it if it does not.
The Salesforce connector is a CozyRoc, but I would imagine it would be done the same if the starting point was a flat file or any other source besides SQL Server. The destination I'm using is OLE DB for a SQL Server 2005 Database, I do have an ID field that will match on both sides and and Local SQL Id I can also use.
Any thoughts on how best to do this would be wonderful.
Thanks!! 🙂
April 20, 2011 at 12:19 am
I just explained in another topic how such a thing can be done with standard components:
http://www.sqlservercentral.com/Forums/Topic1096064-148-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 20, 2011 at 8:14 am
I'll second Koen's suggestion. I was going to suggest exactly what is in the other thread.
Edit: fixed spelling of name. Check out Phil's post to see how I misspelled it:-D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 20, 2011 at 8:17 am
Jack Corbett (4/20/2011)
I'll second Keon's suggestion. I was going to suggest exactly what is in the other thread.
Who's this Keon then? 🙂
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 20, 2011 at 12:10 pm
Thanks!!! I'll check that out and attempt later this afternoon. It seems fairly straight forward so hopefully I'll be able to figure it out.
April 20, 2011 at 11:36 pm
Jack Corbett (4/20/2011)
I'll second Koen's suggestion. I was going to suggest exactly what is in the other thread.Edit: fixed spelling of name. Check out Phil's post to see how I misspelled it:-D
:blink:
Blashphemy!
😀 Don't worry, I've got quite an impossible name for English speaking people (at least for pronouncing it correctly. Writing it should not be so bad :-D)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 20, 2011 at 11:37 pm
eagb (4/20/2011)
Thanks!!! I'll check that out and attempt later this afternoon. It seems fairly straight forward so hopefully I'll be able to figure it out.
If you have any questions or issues, feel free to drop a note.
Good luck!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply