How do I add this to the Toolbar in Visual Studio 2010?

Nov 8, 2012 at 4:03 PM
Edited Nov 9, 2012 at 2:50 PM

I have installed the SSIS GoogleAnalyticsSource but I have not been able to find the UI panels (like the screenshots on the website) anywhere nor they appeared in my SSIS toolbox. How do I use this component? I am using SQL Server 2012 with Visual Studio 2010.

Nov 23, 2012 at 10:00 AM
Edited Nov 23, 2012 at 10:07 AM

Hello @all,

I have the same issue. I installed SSIS-source, but cannot add it to the Toolbox in BIDS 2010. Any ideas?

Regards,

Andrey

 

P.S. I found this post in the forums:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/4daf48fd-8550-405f-8a46-21c4258b3aab/

do we have this issue?

Coordinator
Nov 23, 2012 at 11:14 AM

Hi,

Please check your GAC. With .NET 4.0 it has changed to "C:\Windows\Microsoft.NET\assembly".

For BIDS 2012 it is not necessary (and as far as I know not possible) to add components manually.
Even if the component is a datasource, it sometimes appears in some other groups.

The Forum article refers to SQL Server 2008 and BIDS 2008.

Cheers,

Tillmann

Nov 23, 2012 at 1:15 PM

Hello @all,

".....

For BIDS 2012 it is not necessary (and as far as I know not possible) to add components manually.
Even if the component is a datasource, it sometimes appears in some other groups.

..."

Nice hint! In my case it was in group "Common".

Cheers,

Andrey

Dec 3, 2012 at 10:45 AM

Hello

I was not so fortunate. Nothing changes after I run the install. The new component is nowhere to be found, not even under "Common".
My machine has quite a unique configuration, due to SSDs and such... Is there any way to manually install the component DLL? 

Thanks

George

Jun 11, 2013 at 10:00 AM
Edited Jun 11, 2013 at 10:02 AM
hello

I got same issues.

To sum up :
OS :     Windows 7
VS  :    Version  2010 
BDD ;  SQLSERVER  2012 
I don't know how to detect that GoogleAnalytics Component on BIDS 2010.
Indeed , i can't see the DataFlow Component Items and ControlFlow component items on SSIS toolbar.
It seems on 2012 Version theses options didn't exists.

So question : How can we do to add an specific component as GoogleAnalytics ?
I used the refresh toolbar when i clicked right on SSIS toolbar. but unfortunately it doesn't work.
Can you help me ?

The different solution that i try are :
Solution 1 :
                - To copy the DLL on GoogleAnalytics and paste on PipelineComponents 
                - Open VS2010 
                - Refresh SSIS toolbar 
Result 1 : KO

Solution 2 :
              -  To copy the DLL on GoogleAnalytics and paste on PipelineComponents 
               - use syntaxe devenv/resetSettings on command line
Result 2 : KO


I hope get an solution
thanks by advance

Neo
Coordinator
Jun 11, 2013 at 10:22 AM
Edited Jun 11, 2013 at 10:22 AM
Hi Neo,

Look at one of the previous posts:
For BIDS 2012 it is not necessary (and as far as I know not possible) to add components manually.
Even if the component is a datasource, it sometimes appears in some other groups.
Otherwise, check that you have opened the SSIS Toolbox and not the Toolbox.

Cheers,

Tillmann
Jun 11, 2013 at 11:55 AM
hi tillmann

i got BIDS 2010 not BIDS 2012
and i opened the SSIS toolbox and i didn't find that component , i refresh the tool but none result concluded
So i supposed i can put the DLL named "SSISComponents.Dts.Pipeline.GoogleAnalyticsSource.dll" on GAC but unfortunately it doesn't work.
Do you think i should upgrade on BIDS 2012 , is that something recommanded?


Cheers,
Neo
Coordinator
Jun 11, 2013 at 12:18 PM
Edited Jun 11, 2013 at 12:19 PM
Hi Neo,

ok, misnomer on my side. With SQL Server 2012 you get SSDT (previously known as BIDS), based on Visual Studio 2010.
There are no differences between Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 (what you describe as BIDS 2012) and SSDT 2012 from the SSIS perspective. There are only some improvements by the IDE.

The installer should register all assemblies in the GAC.
Please check the .NET 4.0 GAC: %windir%\Microsoft.NET\assembly\

It's no possible to copy assemblies to the GAC, you should use Gacutile.exe for that.

But again: please open a dataflow in SSDT and check again the different groups inside SSIS Toolbox.
Oh and try to open SSDT with "run as Administrator".

Cheers,

Tillmann
Marked as answer by Tillmann on 2/15/2014 at 9:00 AM
Jun 11, 2013 at 3:38 PM
hi tillmann,

That's good , all works
thanks for your help

see you
Feb 26, 2014 at 5:58 AM
Edited Feb 26, 2014 at 8:38 AM
Hi Tillmann,

I'm having a similar problem: VS2012 Premium(11.0.61030.00 Update 4) & SSDT (latest).

Have found SSISComponents.Dts.Pipeline.GoogleAnalyticsSource.dll in
"...Microsoft.NET\assembly\GAC_MSIL\SSISComponents.Dts.Pipeline.GoogleAnalyticsSource\v4.0_1.2.0.0__1eab8a67122c49ca"

Have opened VS as Administrator...
Created a new SSIS project...
Added a Data Flow task...
There is no new task in any of the folder groupings, even after "Refresh Toolbox".

Do you have any advice on what I could try next?

Thank you in advance.

Mark.

PS.
I seem to have a VS2010 shell (+SSDT) and seem to have same problem - this makes me think that the VS2012 is not the problem?

PPS.
Have now tried to install on my work machine - also VS2012/SSDT and all is well.
Still unsure about what is preventing it from working on my home (above) machine.