none
Filter Assignment Records Using Odata Connector in SSIS RRS feed

  • Question

  • Hi

    I'm currently using SSIS to connect to a project online instance to get data to transform into a datawarehouse.

    I am trying to filter the assignment records but it doesn't seem to want to work. I have tried numerous combinations but the validation either fails or it just returns all records. I'm using this article as a base https://msdn.microsoft.com/en-us/library/office/dn794163.aspx.

    My current query filter is $filter=ProjectId eq guid'" + @[User::EachProject_CurrentProjectId] + "'&$format=json

    I have used a script task to ensure the value for the above variable is correct be execution of the step to copy the data and it definitely has the correct value inside the loop. Any assistance would be very helpful

    • Changed type Kirk De Villiers Wednesday, May 31, 2017 12:07 PM No answers are forthcoming
    Friday, May 26, 2017 9:52 AM