Choosing control flow and data flow items?

  • oh...yes,Lynn...i am trying on that...

    Thanks,
    Charmer

  • Charmer (6/21/2012)


    oh...yes,Lynn...i am trying on that...

    So, one of the problems you are having is that you don't see some third party components you have install in your toolbox, correct?

  • Lynn Pettis (6/21/2012)


    Charmer (6/21/2012)


    oh...yes,Lynn...i am trying on that...

    So, one of the problems you are having is that you don't see some third party components you have install in your toolbox, correct?

    if i don't see third party tools , i know that might be due version problem...since those tools has been made for 2008 r2 but i am using 2012 server...so it may not support it...but my problem is, i does see data flow and control flow tab when i click Tools--->Choose Toolbox items....we used to select third party tools from there in Vs 2008 correct? why not in vs 2010? i hope i am not wrong...if i am , please correct me, Lynn..

    Thanks,
    Charmer

  • Charmer (6/21/2012)


    Lynn Pettis (6/21/2012)


    Charmer (6/21/2012)


    oh...yes,Lynn...i am trying on that...

    So, one of the problems you are having is that you don't see some third party components you have install in your toolbox, correct?

    if i don't see third party tools , i know that might be due version problem...since those tools has been made for 2008 r2 but i am using 2012 server...so it may not support it...but my problem is, i does see data flow and control flow tab when i click Tools--->Choose Toolbox items....we used to select third party tools from there in Vs 2008 correct? why not in vs 2010? i hope i am not wrong...if i am , please correct me, Lynn..

    Can't answer that question. I don't VS 2010 at work.

  • oh...Really !!! that's ok Lynn...Thank you for spending some time for me...and i have another issue but i must not discuss that in here...if you help me , i would explain about it in another topic...could you?

    Thanks,
    Charmer

  • Charmer (6/21/2012)


    oh...Really !!! that's ok Lynn...Thank you for spending some time for me...and i have another issue but i must not discuss that in here...if you help me , i would explain about it in another topic...could you?

    None standard 3rd party tools have to be manually added to the tool box after installation from the options menu in SSDT if you are using 2012 or BIDS if 2005/2008/R2 in order to see them in control or data flow toolboxes.

  • anthony.green (6/21/2012)


    Charmer (6/21/2012)


    oh...Really !!! that's ok Lynn...Thank you for spending some time for me...and i have another issue but i must not discuss that in here...if you help me , i would explain about it in another topic...could you?

    None standard 3rd party tools have to be manually added to the tool box after installation from the options menu in SSDT if you are using 2012 or BIDS if 2005/2008/R2 in order to see them in control or data flow toolboxes.

    Anthony, i tried manually like you said....but i dont see any data flow as well as control flow components tab to choose from option menu....thats what my concern is...

    Thanks,
    Charmer

  • Charmer, are you saying that your toolbox is completely empty, or just missing 3rd party tools?

    If the former, I'm not sure how to help unless you can right-click the toolbox and select Reset Toolbox. I've never had to do that so not sure how much of a reset you really get.

    If the latter, right-click toolbox and select Choose Items. That dialog should allow you to load 3rd party and custom tools.

    But, I also am on 2005, so can't help on how that is different from vs2010.

  • herladygeekedness (6/21/2012)


    Charmer, are you saying that your toolbox is completely empty, or just missing 3rd party tools?

    If the former, I'm not sure how to help unless you can right-click the toolbox and select Reset Toolbox. I've never had to do that so not sure how much of a reset you really get.

    If the latter, right-click toolbox and select Choose Items. That dialog should allow you to load 3rd party and custom tools.

    But, I also am on 2005, so can't help on how that is different from vs2010.

    I have Visual Studio 2010 Ultimate at home. I'll try to remember to check it out tonight.

  • Lynn Pettis (6/21/2012)


    herladygeekedness (6/21/2012)


    Charmer, are you saying that your toolbox is completely empty, or just missing 3rd party tools?

    If the former, I'm not sure how to help unless you can right-click the toolbox and select Reset Toolbox. I've never had to do that so not sure how much of a reset you really get.

    If the latter, right-click toolbox and select Choose Items. That dialog should allow you to load 3rd party and custom tools.

    But, I also am on 2005, so can't help on how that is different from vs2010.

    I have Visual Studio 2010 Ultimate at home. I'll try to remember to check it out tonight.

    My installation of VS2010 Ultimate does not have the capability of creating or modifying SSIS packages, so I can't help here.

  • Looks like it should be automatic.

    What I am guessing is this

    Installed SQL 2008 with BIDS etc etc

    Then installed the 3rd party tools

    Then installed SQL 2012?

    If so the DLL's wont be in the SSDT environment

    This link shows more http://fendy-huang.blogspot.co.uk/2011/09/how-to-add-ssis-custom-component-to.html. But looks like you might have to reinstall /copy the 3rd party components into the right areas

  • Lynn Pettis (6/21/2012)


    My installation of VS2010 Ultimate does not have the capability of creating or modifying SSIS packages, so I can't help here.

    SSIS is not available in VS2010.

    http://blogs.msdn.com/b/mattm/archive/2010/05/13/ssis-and-visual-studio-2010.aspx

    http://connect.microsoft.com/SQLServer/feedback/details/508552/ssis-vs2010-project-type

    Far away is close at hand in the images of elsewhere.
    Anon.

  • David Burrows (6/22/2012)


    Lynn Pettis (6/21/2012)


    My installation of VS2010 Ultimate does not have the capability of creating or modifying SSIS packages, so I can't help here.

    SSIS is not available in VS2010.

    http://blogs.msdn.com/b/mattm/archive/2010/05/13/ssis-and-visual-studio-2010.aspx

    http://connect.microsoft.com/SQLServer/feedback/details/508552/ssis-vs2010-project-type

    Unless you have SQL2012 with SQL Server Data Tools installed as thats now built on VS2010

  • herladygeekedness (6/21/2012)


    Charmer, are you saying that your toolbox is completely empty, or just missing 3rd party tools?

    If the former, I'm not sure how to help unless you can right-click the toolbox and select Reset Toolbox. I've never had to do that so not sure how much of a reset you really get.

    If the latter, right-click toolbox and select Choose Items. That dialog should allow you to load 3rd party and custom tools.

    But, I also am on 2005, so can't help on how that is different from vs2010.

    i meant not completely empty....when i right click and select choose items, i don't see data flow and control flow tabs in the dialog box...

    that is what i am looking for...

    Thanks,
    Charmer

  • David Burrows (6/22/2012)


    Lynn Pettis (6/21/2012)


    My installation of VS2010 Ultimate does not have the capability of creating or modifying SSIS packages, so I can't help here.

    SSIS is not available in VS2010.

    http://blogs.msdn.com/b/mattm/archive/2010/05/13/ssis-and-visual-studio-2010.aspx

    http://connect.microsoft.com/SQLServer/feedback/details/508552/ssis-vs2010-project-type

    yes as anthony said, we need sql 2012 to use vs 2010..

    Thanks,
    Charmer

Viewing 15 posts - 16 through 30 (of 33 total)

You must be logged in to reply to this topic. Login to reply