Post reply

Using expression in Sharepoint List source and destination

  • September 1, 2010 at 4:11 pm

    #223298

    Hi,

    I am trying to pass a variable to sharepoint URL and sharepoint list name in SharePoint List task, so dynamically I can look at mutiple URL's and load data to sql database. I am configuring this in dataflow task, but I don't think URL is changing dynamically in SharePoint List item. Please advise how I should implement expressions in SharePoint List and Destination tasks.

    Thanks

  • September 2, 2010 at 3:45 pm

    #1215958

    Mahi-667326 (9/1/2010)

    Hi,

    I am trying to pass a variable to sharepoint URL and sharepoint list name in SharePoint List task, so dynamically I can look at mutiple URL's and load data to sql database. I am configuring this in dataflow task, but I don't think URL is changing dynamically in SharePoint List item. Please advise how I should implement expressions in SharePoint List and Destination tasks.

    Thanks

    Right-click on the data flow canvas and select Properties. Then scroll down and look for a property named like [SharePoint Source].[SiteUrl]. This is the component property you have to modify with dynamic expression.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply