SSIS w/ SQL Server 2005 and VS2008?

[elhaix]

I've designed SSIS packages with VS 2005 and SQL Server 2005 installed.

For my next project, I'm using VS 2008, and installing SQL Server 2005.

I've already gone through the install process once, installing the business/integration services options for SQL Server 2005, which to my knowledge should add the BI shell to VS. However, I don't see the option to work on SSIS packages in VS 2008.

What's the solution?

 

[elhaix]

... would I have to develop the SQL Server 2005 SSIS package with VS 2005 and just execute it through my 3.5 code in VS 2008?

 

[mrdenny]

SSIS packages for SQL Server 2005 are edited in Visual Studio 2005. To use Visual Studio 2008 you'll need SQL Server 2008's SSIS which may not be compatible with SQL Server 2005.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[MDXer]

SSIS 2008 is installed as part of the SQL 2008 install. Remember BIDS and VS are actually seperate products that use a common interface. Just as if you installed VB.NET 2005 and C# 2008 you wouldn't be able to build a VB.NET 08 app without first installing VB.NET 08.

After installing BIDS 08 you will be forced to migrate your packages as you open them in BIDS 08. once you have migrated and edited a package in 08 you will be unable to edit them in 05.