When i try to create a dts package in Busness intelligence development studio(sal server 2008 R2),im getting the follwing 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: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services. Please help me to resolve this problem

Must be SSIS is not installed (when you were installing SQL Server you did not chose it). To resolve: add the "Integration Services" feature to the existing installation of BIDS. To do this, rerun the Setup program, and then select Add Features to an Existing Installation. For more information, visit the following MSDN Web site: http://msdn.microsoft.com/en-us/library/cc281940.aspx This article has the complete post http://support.microsoft.com/kb/963070Arthur My Blog

Hi, I installed express edition of sql server 2008 r2.whether it supports ssis and ssrs. Thanks.

http://msdn.microsoft.com/en-us/library/cc645993.aspx . Express does not support the Integration Services designer and runtime.http://deepaksqlmsbusinessintelligence.blogspot.com/ Happy to help! Thanks. Regards and good Wishes, Deepak.