Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
add comment

3 Answers

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

share|improve this answer
add comment

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.

share|improve this answer
    
I assume "workstation components" are not the same as "client components", are they? Because i do install each client component: connectivity, bids, software dev kit, management studio. I am able to start BIDS, but SSIS project templates are missing –  Franz Jun 29 '10 at 11:51
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.