none
dtproj and dtsx in Visual Studio 2010?

    Question

  • I have some SSIS packages (dtsx) in a sln and dtproj that were created in VIsual Studio 2008. I went through the conversion process in Visual Studion 2010, but when I try to open them, I get an error that dtproj is not supported in this version.

    What can I do so I can work with these is VS 2010?





    • Edited by DavefromMD Friday, May 10, 2013 12:37 PM
    Friday, May 10, 2013 12:31 PM

Answers

  • I tried creating a new project in VS 2010. There was no option under the available projects list for an SSIS project. So, I tried creating an empty solution (under the "other" options) and then I copied in the existing VS 2008 package into it. When I opened the package  all it would show me was the configuration string.

    I did a little more research and found what appears to be the answer - VS 2010 does  not support SSIS projects unless SQL Server 2012 is installed. Not sure if that meant usings the SQL Server 2012 BIDS or if VS 2010 then recognized SSIS projects.  

    So it looks like if you have VS 2008 SSIS projects using SQL Server 2008 or 2008R, you can't use VS 2010 with them.

    Friday, May 10, 2013 4:30 PM
  • I tried creating a new project in VS 2010. There was no option under the available projects list for an SSIS project. So, I tried creating an empty solution (under the "other" options) and then I copied in the existing VS 2008 package into it. When I opened the package  all it would show me was the configuration string.

    I did a little more research and found what appears to be the answer - VS 2010 does  not support SSIS projects unless SQL Server 2012 is installed. Not sure if that meant usings the SQL Server 2012 BIDS or if VS 2010 then recognized SSIS projects.  

    So it looks like if you have VS 2008 SSIS projects using SQL Server 2008 or 2008R, you can't use VS 2010 with them.


    Hi Dave,

    You are completely right. The Business Intelligence Development Studio (BIDS) shipped with SQL Server 2008 (R2) cannot integrate with Visual Studio 2010. The BIDS installed by SQL Server 2012 uses Visual Studio 2010 shell and can integrate with Visual Studio 2010. Unless you have got specific edition of SQL Server 2012 installed, you are unable to create new or open existing BI projects in Visual Studio 2010.

    Regards,


    Mike Yin
    TechNet Community Support

    Monday, May 13, 2013 2:27 AM
    Moderator

All replies

  • Try creating a project in BIDS 2010, Once you have completed in the Solution explorer, Right Click and add Existing Package(not new) one by one.

    Regards, RSingh

    • Proposed as answer by Nitesh Rai Friday, May 10, 2013 1:22 PM
    Friday, May 10, 2013 12:47 PM
  • What is BIDS?
    Friday, May 10, 2013 1:06 PM
  • What is BIDS?

    Visual studio with BI templates. You can use Visual studio also. BIDS can be accessed by All Programs->MS SQLServer 2005/08->SQL Server Business Intelligence Studio. For SQL Server 2012 it is known as SSDT (SQL Server data tools)

    Nitesh Rai- Please mark the post as answered if it answers your question

    Friday, May 10, 2013 1:25 PM
  • Business Intellegence Development Studio(BIDS).

    Regards, RSingh

    Friday, May 10, 2013 2:31 PM
  • I tried creating a new project in VS 2010. There was no option under the available projects list for an SSIS project. So, I tried creating an empty solution (under the "other" options) and then I copied in the existing VS 2008 package into it. When I opened the package  all it would show me was the configuration string.

    I did a little more research and found what appears to be the answer - VS 2010 does  not support SSIS projects unless SQL Server 2012 is installed. Not sure if that meant usings the SQL Server 2012 BIDS or if VS 2010 then recognized SSIS projects.  

    So it looks like if you have VS 2008 SSIS projects using SQL Server 2008 or 2008R, you can't use VS 2010 with them.

    Friday, May 10, 2013 4:30 PM
  • I tried creating a new project in VS 2010. There was no option under the available projects list for an SSIS project. So, I tried creating an empty solution (under the "other" options) and then I copied in the existing VS 2008 package into it. When I opened the package  all it would show me was the configuration string.

    I did a little more research and found what appears to be the answer - VS 2010 does  not support SSIS projects unless SQL Server 2012 is installed. Not sure if that meant usings the SQL Server 2012 BIDS or if VS 2010 then recognized SSIS projects.  

    So it looks like if you have VS 2008 SSIS projects using SQL Server 2008 or 2008R, you can't use VS 2010 with them.


    Hi Dave,

    You are completely right. The Business Intelligence Development Studio (BIDS) shipped with SQL Server 2008 (R2) cannot integrate with Visual Studio 2010. The BIDS installed by SQL Server 2012 uses Visual Studio 2010 shell and can integrate with Visual Studio 2010. Unless you have got specific edition of SQL Server 2012 installed, you are unable to create new or open existing BI projects in Visual Studio 2010.

    Regards,


    Mike Yin
    TechNet Community Support

    Monday, May 13, 2013 2:27 AM
    Moderator