| Author |
Topic |
|
vectra_marian
Starting Member
5 Posts |
 Posted - 2008-05-26 : 10:55:29
|
| I have installed in my machine SQL 2005 with SSIS components, and the Visual studio 2005. The installation process was successfully and all components seem to be on the machine, but I did not find the shortcut to allow me running SSIS environment. When I re-run the SQL setup the SSIS components is there but is unable to be used.Any idea how to solve this issue?Thank you,Marian |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-26 : 11:34:07
|
| How were you trying to launch SSIS? Through Visual studio? |
 |
|
|
vectra_marian
Starting Member
5 Posts |
Posted - 2008-05-26 : 12:18:03
|
| No.I went Start/Microsoft SQL Server 2005 and there I expected to have a shortcut called SQL Server Business Intelligence Development Studio, but it is missing. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-26 : 12:22:14
|
quote:
Originally posted by vectra_marian
No.I went Start/Microsoft SQL Server 2005 and there I expected to have a shortcut called SQL Server Business Intelligence Development Studio, but it is missing.
Have you tried launching Visual Studio 2005 and checked whether there is a project type called Integration Services Project under New-> Project? You can design SSIS packages from Visual Studio 2005 also |
|
|
|
vectra_marian
Starting Member
5 Posts |
Posted - 2008-05-26 : 12:45:40
|
| I've already done, but there is no Integration Services Project under New-> Project. I have Visual basic, Visual c#, Visual C++, Visual J#, and in Other Project Types I have: Setup and Deployment, Database, Extensibility, and Visual Studio Solutions.I checked other workstations where I installed the SSIS from the same kit and they could either run SQL Server Business Intelligence Development Studio from Visual studio 2005 or runt the shortcut.What test can I perform to see if the SSIS is really installed? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-26 : 13:11:58
|
quote:
Originally posted by vectra_marian
I've already done, but there is no Integration Services Project under New-> Project. I have Visual basic, Visual c#, Visual C++, Visual J#, and in Other Project Types I have: Setup and Deployment, Database, Extensibility, and Visual Studio Solutions.I checked other workstations where I installed the SSIS from the same kit and they could either run SQL Server Business Intelligence Development Studio from Visual studio 2005 or runt the shortcut.What test can I perform to see if the SSIS is really installed?
Try installing Integration Services again from SQL server installation CD. |
|
|
|
vectra_marian
Starting Member
5 Posts |
Posted - 2008-05-26 : 14:04:56
|
| I anticipated that you will ask me to do this, and the installation was sucessful, but still I cannot run SSIS.I try to install on other machine to see if still have the same issue.Is it any test that I can do it?Thank you |
|
|
|
vectra_marian
Starting Member
5 Posts |
Posted - 2008-05-26 : 14:07:39
|
| In which order I should install Visual studio and SQL 2005?Thank youMarian |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 20:28:33
|
| Any order, it doesn't matter. |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-06-10 : 15:46:03
|
| I had the same problem. I believe that on my initial installation of sql 2005 client I didn't install the Business Intelligence Development stuff. When I "added" it with a reinstall the he re-installation had no errors but neither the VS project type or the MS Sql Server 2005 menu group appeared.I ended up completely uninstalling sql server then re-installing all the client components. That did the trick. I never touched my Visual Studio installs.Be One with the OptimizerTG |
|
|
|
sunliners81
Starting Member
4 Posts |
Posted - 2008-06-10 : 17:07:46
|
| Make sure that you have IIS installed also. |
|
|
|
|
SSIS does not open and the shortcut is missing