Cheers - already raised a "ticket/issue" http://analyticssource.codeplex.com/workitem/15933

but if it's just Tillmann working on the project then it might be a while for any answer.

I'll ask our DBA to...

anthony.green (1/7/2013)

---

Not all metrics can be exported in 1 DFT, its trial and error, I started with 1 metric then added one in at a time until it wouldnt export...

I've made a start with the SSIS DFT task that's mentioned on "http://analyticssource.codeplex.com/".

I can get the task to login to my google analytics account, and can successfully preview the data...

you could try....

DECLARE @today VARCHAR(10)

select @today = convert(varchar(10),getdate(),120)

then use the parameter in the where clause

AND T.TimeStarted like @today+'%'

or just use

AND T.TimeStarted like (select convert(varchar(10),getdate(),120))+'%'