DTS -> SSIS -> ???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

thomasjbs@gmail.com - 29 Sep 2007 22:25 GMT

Anyone know where SSIS is? I installed the SQL Server 2005 evaluation
and found several app folders, and SSBID, but no SSID.

It took a bit of research to find and install DTS and I finally
imported a flat file of 500+ fields to begin normalizing, but I don't
see an application called SSIS to automate the process.

Reply to this Message

Tibor Karaszi - 30 Sep 2007 08:21 GMT

SSIS is a service, which you have to select when you install (can be added later by running SETUP
again). You create SSIS packages using "SQL Server Business Intelligence Development Studio).

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Anyone know where SSIS is? I installed the SQL Server 2005 evaluation
> and found several app folders, and SSBID, but no SSID.
>
> It took a bit of research to find and install DTS and I finally
> imported a flat file of 500+ fields to begin normalizing, but I don't
> see an application called SSIS to automate the process.

Reply to this Message