Working with Variables

Feb 6, 2013 at 7:53 AM
I want to iterate with a foreach-loop through a set of profiles. So I have this list-object-variable and the string-variable. The string contains the right "ga:12345" ID as I can see in the debugging. Though when I'm inside the data flow and configure the Profile property to "@[User::AnalyticsProfilString]" it will end in a bad request, cause the https string will just write "&ids=@[User::AnalyticsProfileString]" (but it should containt the correct id).
The scope of the variables are at package-level.

Image
Feb 15, 2013 at 7:46 AM
So is there no way to work with variables in this component? I still can't find a way. The component always results the error message
 [SSIS GoogleAnalyticsSource] Error: Google.GData.Client.GDataRequestException: Execution of request failed: https://www.googleapis.com/analytics/v2.4/data?key=...EXR2GVCA&dimensions=ga:pagePath&end-date=2013-01-25&ids=@[User::AnalyticsProfilString]&metrics=ga:pageviews&start-date=2013-01-25&segment=gaid::-1 ---> System.Net.WebException:
   ...
Mar 6, 2013 at 10:52 PM
Edited Mar 7, 2013 at 12:14 AM
I'm new to this project but I think I can help...

Go back to your top-level dataflow task and highlight your dataflow task on the Control Flow tab

In the Properties window, scroll down until you see the +Expressions property

Click on the ellipse button to the right and it will open the Property Extension Editor

Click on the blank cell under "Property" and the drop-down listbox will open, exposing all of the Custom Properties for the GA dataflow.

It's here where you plug in your variables such as @[User::AnalyticsProfileString]


Hope this helps. I was struggling with finding all the expressions myself and it's at the parent Dataflow task level.
Marked as answer by Tillmann on 2/15/2014 at 9:01 AM