SSIS and VS 2010

  • I got my fresh new copy of VS 2010 yesterday and immediately began playing. I want to build an SSIS package. Funny, there wasn't a template for that in the database section. I went to the Web. Dear me lots of people complaining that they couldn't find it either.

    At the tail-end of one long diatribe, there was a note, 'maybe they'll fix it with SQLServer2008 R2'.

    I went looking for R2. It had been released only a few days ago. I spent most of the evening downloading it and then more time installing it.

    I ran BIDS. It opened VS2008. :angry: :angry:

    MS in their wisdom (and displaying an immense lack of any communication between divisions) have set it in concrete - to build an SSIS 2008 package you have to use VS 2008. Never mind that they are two totally different beasts. Never mind that the VS development team have put together Add-Ons for a huge amount of stuff including old and new Frameworks and Databases.

    So I and I am assuming many others will not upgrade any system that uses SSIS to VS 2010, no matter what other benefits we are missing out on, because we can't run it all in the same IDE.

    Good one Microsoft.

  • Well here is the KB article

    http://support.microsoft.com/kb/983332

    Just wondering if anyone has more info on this? As we are trying to use VS2010 for the TFS (Source Control) aspect and BIDs development is rather high on our list.

    Why would MS not include the BIDs templates in VS2010?

  • thanks for this information and link.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply