View Complete Post
I am using SSIS SharePoint List Adapter to load data in and out of my SharePoint Lists from within SSIS, and most of it is working fine. However, I need to perform a lookup against the Users & Groups collection in SharePoint so I can retrieve
the UserID and set the value when writing back to SharePoint. Any help would be tremendously appreciated!
i need to get list of package variable names during execution of a custom control flow task.
Best regards Crom
I've started a new SSIS project which needs to sync daily a SharePoint list into a SQL 2008 database.
Every day the SP list is updated with new suppliers. It is associated to a validation workflow in order to get a clean list.
My SSIS project is looking good so far, when I run it I'm able to get approved records from the SP list into my SQL table.
But I need to go further. I need to tell to the SP list that the datatset I have at the end of my SSIS flow has been synced.
I need to do that in order to have these records only once otherwise at the next run I'll get duplicates.
So my idea was to go for a boolean field in the SP list and update this field and the end of my data flow.
I'm deriving the colum in order to update that in my flow. I set all the records to IsSync == True
But when I run the flow and I check the SP List...only the version field in the SP list has changed and nothing else!
Any help would be appreciated !
I'm working on a Remote sever diff to the Sharepoint & SQL server (3 diff serv)
Firstly i would like to get the package to work before i try & execute the package remotely.
Where can i also find the ssis sharepoint list adapters installer package to install.
Ihave created a Site definition and added a Posts Listview in the same.
<View List="$Resources:core,lists_Folder;/$Resources:core,blogpost_Folder;" BaseViewID="10" WebPartZoneID="Left" WebPartOrder="1"/>
This list is created using my own schema.xml which i have copied from the Blog site template.
I wanted to rename the title of the list [not Title field] which is coming to be Posts right now.
Is there anyway to do it?
Any help appreciated
ÃÂ Is there a list of accessibility acts that SharePoint 2007 supports.ÃÂ For example the Accessibility for Ontarians with Disabilities Act, 2005?
I have a a list that recieves email. I have few fields that shows me the originator: "E-Mail From" and "E-Mail Sender".
I am trying to create a workflow that will generate an auto reply to the originator but the SPD fails to recognize the email address in these two fields. It's either truncating part of it or uses the html ( href=mailto:Demo@DemoSomething.com) in
the To field.
i created a dataview for a user table to insert new records. now i have to use a dropdown list that get data from another table. to insert in my user table. in the user table only the code is stored. but i need to get that code description that is in another
table in my dropdownlist to choose from in my dataview.
how can i do this in sharepiont designer2007?
I am using MOSS 2007 and my requirement is to show tooltip when I hover the mouse over the title column for each item. I am planning on storing the tooltip string for each listitem in a seperate column. Is there a way to do it. I am sure there is. Any help
is greatly appreciated.
Thanks in advance!
I have a sharepoint list[Managers] with groupby sector column. like below
Each Sector group by column data i want to display in label or panel control.
How to do that ? how to write the logic?
How the concurrent for sharepoint list item are are handled.
if two or more users are working on same item. Then how sharepoint process multiple update request for particular list item.