• It is possible to automate deployments of SSIS projects/packages through TFS. I am on the tail end of a proof of concept project of deployment of SSIS, SSRS, SSAS, and Schema from TFS build definitions.

    I made use of several open source MSBuild extensions:

    SSIS: http://sqlsrvintegrationsrv.codeplex.com/

    SSRS: ssrsmsbuildtasks.codeplex.com

    SSAS: http://msbuildextensionpack.codeplex.com/ (For the use of Devenv.exe via command line)

    This is all against SQL Server 2012 instances as well.