Posted on: 11/19/2012 5:30:40 PM | Views : 421

When I try to start a new Integration Services Project, I get the following error:
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 R2:  Standard, Enterprise, Developer or Evaluation.  To install Integration Services, run SQL Server Setup and select Integration Services.
When I go to "Installation Type:" for the "SQLEXPR_x64_ENU.exe" media, I see an installed instance named "SQLEXPRESS2", and the Edition is "Express with Advanced Services".  I try to "Add features to am existing instance of SQL Server R2" and when I get to "Feature Selection", it only lists "Database Engine Services" (with "SQL Server Replication" as a child), and "SQL Client Connectivity SDK".  No mention of Integration Services.
I am interested in using SSIS t ...

Go to the complete details ...