Advantages of installing SSIS?

[Goodie666]

Hello,

I just discovered, while trying to figure out how to cluster SSIS, that the service itself is not cluster aware. However, with proper transaction levels etc. I can get my packages to fail graciously during a node switch.

But at the same time, I just discovered, while reading up on it, that the service itself needs not be installed on the machine for the packages to be created/run/debugged. My question then is the following: if I deploy my packages as files on the hard drive, and not in a package store and run them via SQL Agent, why would I install SSIS if according to Microsoft (

http://msdn.microsoft.com/en-us/library/ms345193.aspx

section "There are some tasks...") I don't have to?

I have a feeling there's more to this and I haven't tested more than by just disabling the service and noticing that packages work just as well, but it could be interesting not to have to tell customers that they must install SSIS to run packages.

Thanks,

Greg

 

[mrdenny]

To have the full functionally of SSIS you'll need to have SSIS installed.

Also don't get used to not having SSIS installed. In SQL Server 2008 in order to run the packages on your workstation you have to install SSIS on your workstation.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL BI 2005 / SQL 2008 DBA / SQL 2008 DBD / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005/2008 / BI Dev (SQL 2005)

My Blog