We've just started to undertake migration from SQL 2000 to SQL 2008, and one issue we've encountered is SSIS development. With SQL 2000 we could just install the client (Enterprise Manager) and develop DTS packages on the developer's PC's. These could then be deployed just like any other exe/code. But with SSIS this doesn't seem possible, unless you buy SQLServer standard edition licenses for every developer pc, you can't develop them standalone. Or the dev's have to remote connect to the development server. We've got Visual Studio 2010 Pro installed (and 2008 pro licences), and we've installed SQL 2008 R2 Express with Advance Services locally as well. Have we missed something obvious??? as this seems very odd

Do you have BIDS installed on the machine??Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Visual Studio 2010 Pro doesn't have SQL server 2008 BI template, so it won't work. But you don't have to buy sql server standard edition, you just need the SQL server developer 2008 edition, it is pretty cheap. once you installed the developer edition in your developer's machine with BIDS selected. you can use the Business Intelligence Development studio (BIDS) to do the SSIS deployment. (Precisely, it will generate a deployment manifest file to do the deployment.)

Oh, yes I do have BIDS, though tbh I'm not sure where from!! But when trying a SSIS project, it says BIDS has to be installed by one of the SQL Server 2008 editions. Ah BIDS came from the SSRS investigation I was doing.

If you installed express edition that does not support reporting service ... If you want BIDS it must any versions other than Expresshttp://uk.linkedin.com/in/ramjaddu