Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_objectFind what is deprecated in SQL Server Denali by using sys.dm_os_performance_counters »
    comments

    If you already have a SQL Server 2008 or a SQL Server 2008 R2 instance then do not install SQL Server Denali as a named instance. If you do so then your current SSIS development environment will be broken. There is a reason there are virtual machines, I recommend using VirtualBox

    With CTP1 of Denali, BIDS is still based on Visual Studio 2008, in a later version it will use the 2010 shell.

    Anyway if you do install Denali as a named instance this is what happens when you try to create a new SSIS project

    Denali SSIS Error

    Here is the text

    ---------------------------
    Microsoft Visual Studio
    ---------------------------
    'C:\Users\Denis\AppData\Local\Temp\temp.dtproj' cannot be opened because its project type (.dtproj) is not supported by this version of the application.

    To open it, please use a version that supports this type of project.
    ---------------------------
    OK Help
    ---------------------------

    Here is also a small video I created

    Click on the SQL Server Denali tag to see all our SQL Server Denali related posts

    About the Author

    User bio imageDenis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
    Social SitingsTwitterFacebookLinkedInHomePageFlickrLTD RSS Feed
    2588 views
    Instapaper

    2 comments

    Comment from: Josh Robinson [Visitor]
    Josh Robinson Thanks for taking the time to post this, ran into this issue on a VM that I used as a base to install on. Didn't have full SQL Server, but had client tools installed and that is enough to cause the problem you listed above.
    11/10/10 @ 14:23
    Comment from: Felipe Ferreira [Visitor] · http://blogs.solidq.com/fferreira
    Felipe Ferreira It would be great if I had read your article a couple of hours ago :)
    now it's too late for me :(

    thanks for the info!
    11/12/10 @ 09:29

    Leave a comment


    Your email address will not be revealed on this site.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)