December 31, 2009 at 10:08 am
There is no ssis project type in vs 2010. This means if you want to be able to have ssis packages, .NET code, and db objects as part of one solution you are out of luck.
Not so great for data warehousing.
Vote here.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=508552
December 31, 2009 at 10:43 am
The SSIS tools (BIDS) are specific to the version of SQL Server you are developing for.
SQL Server 2005 SSIS packages must be built in VS2005.
SQL Server 2008 SSIS packages can be built in VS2005 (and upgraded) or built in VS2008.
Since there are not any plans (at this time) for a 2010 version of SQL Server, there wouldn't be any associated BIDS implementations.
You get BIDS by installing the client tools for SQL Server. And yes, you can install the client tools side by side with no problems (make sure you install in order - 2005 (patch to latest version) then 2008 and patch.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 31, 2009 at 10:48 am
The point was that you couldn't have .NET code written in 2010 or a database project written in visual studio 2010 live in the same solution with ssis packages.
Are you suggesting that you can?
December 31, 2009 at 11:17 am
No - you are right, you cannot have a single solution in VS2010 that includes SSIS packages for a previous version of SQL Server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 31, 2009 at 11:25 am
Would be awesome to see Microsoft just go ahead and ship BIDS components with all Visual Studio releases...especially if they are going to be releasing Visual Studio versions out of sync with SQL Server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply