SSIS

Start by running Microsoft Visual Studio on the server.
If you have issues importing an SSIS package or connecting via Integration Services to a Server,
then the service is not working.
- either start the service (SQL Server Integration Services)
- and check, if the instance is not the default instance for the box, it needs to be set up.


- Modify MsDtsSrvr.ini.xml
Should be in D:\Program Files\Microsoft SQL Server\90\DTS\Binn\
Replace .
with VirtualServername\instancename
- stop and restart the SSIS service


Excel and SSIS
SSIS export to excel works currently only in windows 32 bit environment. An excel file can only be created/copied from another excel template and not from scratch.