Missing Integration Service Template - fixed now

I have installed SQL Server 180 day evaluation as well as SQL Server Express but I cannot add a new SSIS project because the template is not there (- in the non-express instance - only Reporting Services). When I try and redo the SSIS part of setup(Add/Remove programs) the report tells me that it is already installed correctly. I have searched for others having this problem to no avail...

What do I need to do to fix it?

This may be a silly question but just wanted to make sure. Did you check the bottom option in the installation wizard for Workstation components and documentation? Also, when you look at the services, do you see the SSIS service installed?

-- Brian Knight

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install.

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Your configuration should work fantastically. Not sure what gremlin reaked havok in your install but glad everything is fine now! I have your exact config and everything works well.

-- Brian Knight