tag:blogger.com,1999:blog-6393051114813114443.post2729660670718792423..comments2024-01-24T15:38:09.758-05:00Comments on Lee's Blog: Sync Your Database to SharePoint Using SSISLee Richardsonhttp://www.blogger.com/profile/01314803491511307042noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-6393051114813114443.post-41471727051103872442012-03-10T14:28:25.636-05:002012-03-10T14:28:25.636-05:00Hi Lee,
this export from SSIS tech is working as ...Hi Lee,<br /><br />this export from SSIS tech is working as expected. But only the document data ( in binary format) available in SQL Server is not exported to sharepoint column as proper datatype is missing.<br /><br />Can you suggest what must be the Datatype of the Column in Sahrepoint to get the binary data export from sql server via SSIS.?<br /><br />Thanks.<br />SSNAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-21846267553528786192010-04-10T14:58:52.561-05:002010-04-10T14:58:52.561-05:00Olya: over a million records is out of my league. ...Olya: over a million records is out of my league. Maybe the product Jon suggested?Lee Richardsonhttps://www.blogger.com/profile/01314803491511307042noreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-30706419282119751522010-02-24T07:12:35.374-05:002010-02-24T07:12:35.374-05:00Hi Lee,
Your solution is very helpful. I need your...Hi Lee,<br />Your solution is very helpful. I need your advice.We need to synchronize more than million records. Now we are looking how to improve performance.<br />Will be grateful for help.Olgahttps://www.blogger.com/profile/13285914875458008031noreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-58831941360963432442009-01-11T18:07:00.000-05:002009-01-11T18:07:00.000-05:00I got into a bit of an SSIS nightmare for my synch...I got into a bit of an SSIS nightmare for my synchronization scenario, then randomly stumbled on this product that does it:<BR/><BR/>http://www.bryantdesignnetwork.com/ProductDetails.aspx?productID=df4fce13-59b3-4045-a01e-eb0757a96a53<BR/><BR/>No code to write or anything so it was niceUnknownhttps://www.blogger.com/profile/01238846956865667014noreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-10916991914597993162008-08-20T22:53:00.000-05:002008-08-20T22:53:00.000-05:00A better solution is now available - a source /des...A better solution is now available - a source /destination adapter for sharepoint which handles all of that for you automatically. Enjoy.<BR/><BR/>http://www.codeplex.com/SQLSrvIntegrationSrvAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-35193360669690723332008-05-25T21:53:00.000-05:002008-05-25T21:53:00.000-05:00Hello Sir,I am able to compile the code successful...Hello Sir,<BR/><BR/>I am able to compile the code successfully but after compilation in the output i am getting the result as zero rows have been written. There are 31 rows in my database. Any suggestions of why its not writing rows to the list.Unknownhttps://www.blogger.com/profile/10209346056950201203noreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-63355844818013276362008-05-23T15:18:00.000-05:002008-05-23T15:18:00.000-05:00Hi,Thank You very much for the post. I have downlo...Hi,<BR/><BR/>Thank You very much for the post. I have downloaded your code, and tried to run the code with some changes, i am getting the error <BR/><BR/>Error: 0x1 at Script Task, System.IO.Stream GetRequestStream(): The remote name could not be resolved: 'nic-user-dev' <BR/><BR/>any suggestions?Unknownhttps://www.blogger.com/profile/10209346056950201203noreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-33349302739237746942008-04-18T05:55:00.000-05:002008-04-18T05:55:00.000-05:00I have VS 2005 on a client machine and not on the ...I have VS 2005 on a client machine and not on the MOSS server. How can I register the SharePointServices.dll by using the gacutil command? Thankspasqualehttps://www.blogger.com/profile/15871615970521252634noreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-48170874431357568622008-01-29T18:50:00.000-05:002008-01-29T18:50:00.000-05:00Lee, in your article, "Figure 1" clearly shows a V...Lee, in your article, "Figure 1" clearly shows a Visual Basic project being created, but the code you provide in "Listing 1" is clearly for Visual C#. I hope I'm the only one that pulled my hair out on this one before figuring it out...<BR/><BR/>:-J<BR/>JeremyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-59901774367243107492007-11-25T20:18:00.000-05:002007-11-25T20:18:00.000-05:00Your articale was great and is working well, howev...Your articale was great and is working well, however the createsynclist creates lists that does not have the "connect to Outlook' option like a contacts list does. I can see that there is a section in the listhelper file in the Sharepointservices project where you mention 100 = custom list, 101 = document library. 104 = contacts if i am not mistaken however i cannot figgure out where or how to specify this so when the exe is run it creates a list that uses the default contacts view and therefore has the "connect to outlook" option. <BR/><BR/>you can email me at todd.parker@live.com.au<BR/><BR/>Thanks again.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-25323924737443718212007-09-26T09:21:00.000-05:002007-09-26T09:21:00.000-05:00Derek,These are fairly standard Data Warehouse syn...Derek,<BR/><BR/>These are fairly standard Data Warehouse syncing issues and there are a number of standard techniques to resolve. I'd suggest picking up a DW book for the general concepts. <BR/><BR/>As far as the details of retrieving from SharePoint, the article and sample code should be sufficient for retrieving data and comparing for example last modified dates. If not please provide a more specific question as I have done this type of thing and can probably provide guidance.Lee Richardsonhttps://www.blogger.com/profile/01314803491511307042noreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-28898334931413036702007-09-26T09:19:00.000-05:002007-09-26T09:19:00.000-05:00Raging,I'm sorry I really only work in VB when nec...Raging,<BR/><BR/>I'm sorry I really only work in VB when necessary, but the concepts should still apply. If you convert my library code to VB please post of a comment of where to find it, I'm sure the community would find it very useful.Lee Richardsonhttps://www.blogger.com/profile/01314803491511307042noreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-60440101243431386752007-09-25T20:48:00.000-05:002007-09-25T20:48:00.000-05:00Hi,I need to do something similar, but I don't wan...Hi,<BR/>I need to do something similar, but I don't want to delete everything in the list beforehand as some of it is content managed. I need to only add the new records in the DB to the list.<BR/>Any ideas?<BR/>CheersDerekhttps://www.blogger.com/profile/02872801492022905194noreply@blogger.comtag:blogger.com,1999:blog-6393051114813114443.post-25132482120115813612007-08-30T05:25:00.000-05:002007-08-30T05:25:00.000-05:00hi sir your application is very helpful to us. may...hi sir your application is very helpful to us. may i ask if you have a VB version of this application for SSIS sync in Database? thank you very much and god blessEdwardhttps://www.blogger.com/profile/08150363833515536804noreply@blogger.com