No SSIS option in Visual Studio 2008?

  • Just installed VS 2008...

    File... New... Project... but no "Integration Services Project" type is available.

    I'm guessing this is something fundamental. What am I missing here?

    Thanks,

    Greg

  • Have you installed BIDS from SQL install?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • No, I installed VS from a VS disc.

    So... the VS I'm looking for is actually an install off the SQL Server media?

    thanks BTW.

  • Yes. It's better to install both, but the Bus. Intelligence stuff (SSIS) comes from the SQL media.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (7/20/2011)


    Yes. It's better to install both, but the Bus. Intelligence stuff (SSIS) comes from the SQL media.

    To expand on the answer:

    * if you install VS 2008 first, as you did, then SQL Server only installs some templates into VS, so that BI projects can be created

    * if VS is not installed, SQL Server will only install a "shell" of VS, that can only be used to create BI projects

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks for clearing that up for me gang. SSC rocks.

Viewing 6 posts - 1 through 5 (of 5 total)

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