VS2008 error: .dtsproj not supported by VS2008?

Question

User-830563764 posted

I have an old SQL Server 2000 BIDS project for a DTS package.  First, I upgraded to SQL Server 2005 BIDS. 
Then for VS2005, I created a SQL Server 2005 SSIS project (i.e. migrate DTS 2000 package) to run this SSIS/DTS
project.   Until now, on the VS2008, I have no problem running this VS2005 SSIS project for the DTS 2000 package.

We just upgraded the Vista to Windows 7, and I had to re-install Visual Studio 2008 from the CD.  After installing
the VS2008 SP1, running this SSIS project popped up an error:  the .dtsproj cannot be opened because its project
type (.dtsproj) is not supported by this bersion of the application.

What's wrong?   Windows 7?  Both the old and new Visual Studio 2008 have the same version 9.0.30729.1 SP.
I may need to do something on SQL Server 2005 SSIS project in order to run on VS 2008; but I don't remember
anything.

Thanks,
Jeffrey

 

Answer 1

User-166373564 posted

Hi wonjartran

Generally install more component when receive this error message. You could follow the method below, and check whether it is helpful to you,

Visual Studio 2008-> Help | About, packages you see in the list of installed products. If Visual Studio 2008 installation is incomplete, you just need to add the missing components. If it is corrupted, the repair/reinstall is indeed required.

hope it helps you,

With regards

Answer 2

User-830563764 posted

Thanks.

On my new Windows 7, SQL Server Integration Services was missing.  
Installed SQL Server 2008 client tools, including Integration Services,
on the new Windows 7.  Now I can open my SSIS 2005 project.