Discussion:
ssis - unable to install properly?
(too old to reply)
sean_walsh
2009-06-10 11:23:01 UTC
Permalink
hi

i'm trying to get sql server integration services installed, so i can
use sql server 2005's version of data transformation services. i have
sql 2000 on my machine, as well as 2005 & 2008. i have just upgraded
with the latest version of SQLEXPR_ADV.EXE from microsoft, think it's
sp3. then i upgraded with the latest version of SQLEXPR_TOOLKIT.EXE
from microsoft, also sp3 i think.


now i have be business intelligence development studio. only when i
click new -> project, there are no templates for integration
services.
only option available to me is the reporting services.


what am i missing? how do i get to create a 2005 "dts package" with
all this?!?


thanks
sean
Todd C
2009-06-11 16:27:01 UTC
Permalink
Hello Sean:
You may need to run through the installation process again for SQL 2005 and
make sure you select the Integration Services component to be installed.

HTH
=====
Todd C
Post by sean_walsh
hi
i'm trying to get sql server integration services installed, so i can
use sql server 2005's version of data transformation services. i have
sql 2000 on my machine, as well as 2005 & 2008. i have just upgraded
with the latest version of SQLEXPR_ADV.EXE from microsoft, think it's
sp3. then i upgraded with the latest version of SQLEXPR_TOOLKIT.EXE
from microsoft, also sp3 i think.
now i have be business intelligence development studio. only when i
click new -> project, there are no templates for integration
services.
only option available to me is the reporting services.
what am i missing? how do i get to create a 2005 "dts package" with
all this?!?
thanks
sean
Loading...