Hi:

I've been using DTS for awhile and soon will start using SSIS in SQL
Server 2005. I liked DTS as an ETL tool and imagine I'll like using
SSIS. Unfortunately when I work with customers who don't have SQL
Server and aren't interested in buying they don't want to buy an entire
SQL Server license. Is it necessary to buy an entire license of SQL
Server to get SSIS? If not, how does buying SQL Server compare with
buying ETL tools on their own?

Thanks,
Kayda

SSIS is not available seperately. You need to have valid SQL Server
licensing (processor or CAL based) in order to use SSIS.

However, most of the time SQL Server licensing compares *very* favorably
with that of stand alone ETL tools. Compared to Business Objects,
Informatica, Ascential or Oracle tools, SSIS is pretty cheap. When you
factor in that you then also get the database, reporting, and analysis stuff
it's usually a no-brainer.

"Kayda" wrote:

Good points, I have a related question:

If our organization has a (processor type) license for SQL Server
Enterprise, is it ok to execute SSIS packages on a client computer - or
do I need to run the packages on the SQL server itself?

I want to do some rougue (but production-level) ETL on a computer with
the client software, without actually putting the packages on SQL
server. (-gosh I hope I don't need to get another copy of SQL server to
keep this process 'exclusive'...)



*** Sent via Developersdex http://www.developersdex.com ***