Scribe Workbench Update Source
Posted
by Dave Noderer
on Geeks with Blogs
See other posts from Geeks with Blogs
or by Dave Noderer
Published on Fri, 07 May 2010 19:21:36 GMT
Indexed on
2010/05/11
2:55 UTC
Read the original article
Hit count: 464
I’ve been working with a program Scribe, similar in function to SSIS although I’m still an SSIS fanboy!!
The main feature my customer has Scribe for is to load data into Microsoft CRM 4.0.
A lot of what I’ve been doing is loading campaigns into CRM which are staged in SQL Server but I need to mark each one as imported so it will not get imported again.
The screen shot below shows how to setup the Source update. One important thing is that the source SQL table has to have a primary key defined (this was a staging table and I did not do that at first)
© Geeks with Blogs or respective owner