Wednesday 8 December 2010

Use SharePoint List Data Source and Destination

There are many scenarios when we need to pull data from SharePoint List.
I have done this many times but by Querying SharePoint Database.
Curtsy to following blogs –

http://weblogs.sqlteam.com/jhermiz/archive/2007/08/15/60288.aspx

Now we have something called SharePoint List Source and Destination available. This makes my job quit easy. Following is reference for the same -

http://msdn.microsoft.com/en-us/library/dd365137(SQL.100).aspx

Good thing is same kind of source are available at Reporting level as well so you can create reports on SharePoint List Data .. Following is reference for same

http://msdn.microsoft.com/en-us/library/ee633650.aspx
Posted by Gaurav Gupta at 23:33
Labels: ,

2 comments:

  1. JSH4 December 2012 at 13:53

    Hi, I am using the SP source to pull a SP list into a SQL database. The problem I am having is that some of the columns have formatted text in them. All I want is the values stored in my varchar(max) SQL columns but I'm getting the xml tags as well. Most of the values do not have tags but some do. When i look at the List data on the SP webinterface, I do see some formatting for these values. Any way to easily remove these tags or ignore formatting?

    Here are some examples of values coming thru (I had to replace the >< signs with " because your html editor didnt like it:
    "div"Vmware Virtual Machine"/div" "div" "/div"

    "div""font color="black""Vmware Virtual Machine"/font""/div"

    "div"Vmware Virtual Machine"/div"


    ReplyDelete
  2. Jack Dowson5 May 2023 at 15:22

    AI is fundamentally making calculations and programming that is client experience. The experience or, as it is called, 'information model' can be saved to certain information stockpiling (kind of a high level instance of content-driven advancement). In view of this model, a similar calculation can be adjusted to be utilized in various runtimes or in any event, for various errands. Composing the calculation is mind boggling and requires a numerical foundation since every one of the approaching information (pictures, text information, sound) ought to be handled to numbers or like numbers structures called tensors and afterward passed to brain organizations, where it very well may be handled. Likewise, how much information that ought to be utilized to come by solid outcomes should be enormous, at times, it can incorporate petabytes of data>> Mobilunity

    ReplyDelete

Subscribe to: Post Comments (Atom)