Finally had some time to install Denali (on my Windows 7 machine with SQL 2008 already running). Unfortunately I found out that after the installation of SQL 2012, I couldn't edit my existing SSIS 2008 projects and I couldn't create a new one. Other project types didn't have any problems but SSIS did:
 |
| Aargh! |
Solution
Max Trinidad found a solution to get SSIS 2008 working again. He had the same problem with SSIS 2008 R2.
Short version:
1) Remove SQL 2012
2) Remove BIDS 2008
3) Restart
4) Add BIDS 2008
5) Install SQL 2012 on a different PC or VPC!
For detailed information go to the blog of Max Trinidad found.
* Update: see release notes *
BIDS Is Not Supported in Side-By-Side and Upgrade Scenarios
Business Intelligence Development Studio (BIDS) is not supported in the following situations:
- Microsoft SQL Server Code-Named “Denali” CTP1 BIDS is installed on the same server as an earlier release of MS SQL Server BIDS.
- An earlier release of Microsoft SQL Server with BIDS is upgraded to Microsoft SQL Server Code-Named “Denali” CTP1.
No comments:
Post a Comment
Please use the SSIS MSDN forum for general SSIS questions that are not about this post. I'm a regular reader of that forum and will gladly answer those questions over there.
All comments are moderated manually to prevent spam.