Posts tagged ‘VS project template’
SSIS project template missing
I have tried to create a SSIS project to import data from some flat files. However, I cannot find any SSIS project template in Visual Studio 2005. I have already installed VS 2005 and SQL Server 2005 in my machine.
Finally I figured out this problem, which is caused by the installation order of VS 2005 and SQL Server 2005. If you have the same problem, you can fix this by following below steps:
- Remove all SQL Server 2005 compoents first (which will remove SQL 2005 Express installed during VS 2005 setup)
- Then reinstall SQL Server 2005 and ensure to select client compoents in installation options.
- After success installation, you will find ”Business Intelligence Development Studio” under Programes > SQL Server 2005. To remind, please ensure to install latest service patch for MS SQL Server 2005.
Hope your problem will be solved.