SSIS - sql server integrated services - like OLAP?
in [Programming SQL]
|
Prev: Help us understand this sql script built by a vendor
Next: how to strip specific email address from nvarchar field with multi
From: Rich on 1 Jul 2008 12:50 Question: is SSIS (sql server 2005 and higher) like online analytic processing? Does it involve cubes at all? My place may be stepping up to sql server 2005 from 2000. The big buzz word is SSIS. Any explanations appreciated on what SSIS entails. Thanks, Rich
From: Tibor Karaszi on 1 Jul 2008 13:33 SSIS is just the successor of DTS. Sure, you can process a cube using SSIS, but as an ETL tool it has usages both for cube/AS scenarios as well as pure OLTP scenarios. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rich" <Rich(a)discussions.microsoft.com> wrote in message news:3A6260A1-6335-44FE-96E9-F65DA7AEAFAF(a)microsoft.com... > Question: is SSIS (sql server 2005 and higher) like online analytic > processing? Does it involve cubes at all? My place may be stepping up to > sql server 2005 from 2000. The big buzz word is SSIS. Any explanations > appreciated on what SSIS entails. > > Thanks, > Rich
From: Tom Dacon on 1 Jul 2008 13:36 It's a replacement for 2000's DTS, and a considerable rewrite and extension over what you could do in 2000. It has nothing to do with cubes, but is a worthwhile way to update the data warehouses that you'd use Analysis Services to generate cubes from. The learning curve on SSIS is a bit steep, but well worth it in my opinion. Likewise with SSAS. The Books Online tutorials on both are good, and I found the following books useful: Microsoft SQL Server 2005 Integration Services Kirk Haselden Sams Publishing Microsoft SQL Server 2005 Analysis Services Step by Step Reed Jacobsen, Stacia Misner Microsoft Press Tom Dacon Dacon Software Consulting "Rich" <Rich(a)discussions.microsoft.com> wrote in message news:3A6260A1-6335-44FE-96E9-F65DA7AEAFAF(a)microsoft.com... > Question: is SSIS (sql server 2005 and higher) like online analytic > processing? Does it involve cubes at all? My place may be stepping up to > sql server 2005 from 2000. The big buzz word is SSIS. Any explanations > appreciated on what SSIS entails. > > Thanks, > Rich
From: Rich on 1 Jul 2008 14:05
Thank you all for your replies and book references. This should get me started. "Rich" wrote: > Question: is SSIS (sql server 2005 and higher) like online analytic > processing? Does it involve cubes at all? My place may be stepping up to > sql server 2005 from 2000. The big buzz word is SSIS. Any explanations > appreciated on what SSIS entails. > > Thanks, > Rich |