There are no usable controls in this group SSIS VS2010

Posted on 2012-09-20
Last Modified: 2012-09-25
Win7 Ent 64bit
BIDS Integration Services Project

All of my controls in the toolbox are gone.  I've tried deleting .tbd files in AppData\Local\Microsoft\VisualStudio\10.0, rightClick->reset Toolbox, even reinstalled VS.  When I'm in data flow, I can see all the tools in SSIS toolbox, but when I switch to control flow and go to Toolbox, no controls are listed but the message 'there are no usable controls in this group.  drag an item into this text to add it to the toolbox'.  If I rightClick and select show all, the controls are there but they're all grayed out.  

any thoughts?
Question by:darrennelson
    LVL 13

    Expert Comment

    Did you by chance make sure that all hidden or system .tbd files were also deleted?

    Are you using VS 2012 or VS 2010?

    Or you are using VS2012 trying to access tools from VS 2010?

    Try backing up then erasing the *.tbd files from the VS2012 appdata directory also. (along with the 2010). Start up Visual studio 2010, then close it. THEN start up vs 2012.

    Hopefully this should regenerate the tools in the proper order to be reused.

    I found this from another forum:

    I can only think that for some reason Visual Studio is telling you that component is not compatible with the form you want to drop it on. Maybe the wrong framework version??

    Try this... Instead of adding the control by drag and drop try adding it programmatically. If it fails it should give you an exception that will point you in the right direction.

    1	myForm_Load(object sender, eventargs e)
    2	{
    3	   GenericUpdate test = new GenericUpdate();
    4	   this.Controls.Add(test);
    5	}

    Open in new window

    Try that out (or another control) and let us know what exception appears (or not)

    Accepted Solution

    sorry, its VS2010

    not sure what happened but here's the solution.  when i switch from data flow to control flow, the focus wasn't on a taksl, so the SSIS toolbox controls didn't change.  The task I was looking for is 'send mail task'.  When i clicked the 'data flow task' in control flow, the tools in SSIS toolbox change to applicable tools for control flow.  I've only been working with this for a few days, but I could have sworn that the control flow tools were in the regular toolbox and not the SSIS toolbox.

    Author Closing Comment

    figured it out

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now