Exporting data from SQL Server 2005 to Excel using SQL Server Integration Services (SSIS) is one of the simple ways of data transfer. Building this application is a one time efforts and can you be anytime on-demand.   read more »