HI We have a SQL 2008 server without SSIS on it. What do we need to run an SSIS package with out installing SSIS? Thanks in advance for the help.

You have to install SSIS. You don't need to install Business Intelligence Development Studio, but you do need to check the SSIS box in the SQL feature install list. SSIS is not redistributable like DTS was. Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer