无法使用SQL 2008 R2 SP3在VS2008中使用BIDS [英] Unable to get BIDS working in VS2008 using SQL 2008 R2 SP3
问题描述
我必须为SQL Server 2008 R2 SP1创建一个SSIS包
I have to create an SSIS package for SQL Server 2008 R2 SP1
我已经在我的机器上安装了SQL Server 2008并检查了安装的所有框,包括整合服务。
I have installed SQL server 2008 on my machine and check all the boxes for the install which includes the integrsation services.
我还安装了VS2008,它提供了创建IS项目的选项。
I have also install VS2008 which gives the the option to create IS projects.
每次我尝试创建项目时,我都会得到: -
Each time I try and create a project I get: -
要在Business Intelligence Development Studio中设计Integration Services包,必须通过SQL Server 2008的其中一个版本安装Integration Services:Standard,Enterprise,Developer或Evaluation。要安装Integration Services,请运行
SQL Server安装程序。
To design Integration Services packages in Business Intelligence Development Studio, Integration Services has to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server setup.
我已尝试卸载和安装,但似乎没有任何帮助。
I have tried uninstalling and installing but nothing seem to help.
VS 2008是V9.0.30729.4462 QFE
VS 2008 is V9.0.30729.4462 QFE
SQL版本是: -
SQL Version is: -
Microsoft SQL Server 2008 R2(SP3) - 10.50.6000.34(X64)  ;&NBSP; 2014年8月19日12:21:34 版权所有(c)Microsoft Corporation 在Windows NT 6.3上使用高级服务(64位)的Express Edition< X64> (Build 17134:)
Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014 12:21:34 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.3 <X64> (Build 17134: )
推荐答案
Express Edition Windows NT 6.3上的高级服务(64位)< X64> (Build 17134:)
Express Edition with Advanced Services (64-bit) on Windows NT 6.3 <X64> (Build 17134: )
免费的Express Edition不支持SSIS,甚至不支持高级服务版本,请参阅
SQL Server版本支持的功能
这篇关于无法使用SQL 2008 R2 SP3在VS2008中使用BIDS的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!