Home / server / Questions / 155848
In Process
Francesco Abeni
Asked: 2010-06-30 01:19:15 +0800 CST

BIDS and SSIS projects on SQL Server 2005

  • 772

I have trouble just getting started with BIDS, the development environment for creating SSIS packages in SQL Server 2005. I don't know if it is just a license / version issue or if i am missing some components.

If i install SQL Server Express 2005, there is NO BIDS component.

If i install SQL Server Express 2005 Toolkit, there IS BIDS component; but when i try to create a new project, there is NO "SSIS package" project template.

I try to install it on different machines, with same results.

Thank you for any suggestion.

sql-server sql-server-2005 ssis

3 Answers

  1. SQL Server 2005 Express (and Workgroup) Edition BI Development Studio only includes the Report Designer.

    • 1

  2. You need to make sure the installer installs 'workstation components' - sometimes it doesn't install these by default. Known annoyance with the SQL Server 2005 installer and I've seen this asked on SO before so you're not the only one who's bumped into this.

    • 0

  3. Yes, i am answering myself. I put my hands on a "Standard edition" SQL Server 2005 CD, installed "client components" as i did before, et voilà, the SSIS projects are now available.

    My conclusion: you cannot create SSIS packages with SQL Server 2005 Express Edition.

    • 0