Input string was not in a correct format

Oct 2, 2012 at 12:28 PM
Edited Oct 3, 2012 at 6:57 AM

When I access the component, we get:

Error: 0x0 at Data Flow Task, SSIS GoogleAnalyticsSource: System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.String.System.IConvertible.ToInt32(IFormatProvider provider)
   at System.Convert.ToInt32(Object value, IFormatProvider provider)
   at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.set_Item(Int32 columnIndex, Object value)
   at SSISComponents.GoogleAnalyticsSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)

environment: MSSQL 2008 R2 SSIS running in VS2008 SP1

Also, the output flat file shows 1 row returned even though several should be returned by google (preview button also not working properly! :( )

i tried to query dims: date, source and medium and metrics: goal 16 value or bounces or visits (each time a single one), nothing seems to work.

similar post -