How can I find out whether SSIS is installed in the server?

Thanks a lot.

What exactly do you mean? By script/scheduling or simply looking for file system for any DLL or whatever?

|||Have a look at the service SQL Server Integration Services, if it is present you have SSIS installed. YOu can check that by open the SCM or type in the "net start" on the commandline on the server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Thanks. I checked SQL Server Integration Services. It is disabled. I just started. Thanks.