I always see TFS being used for application code. Rarely do I see TFS being used for databases, SSIS, or SSRS. Many believe there is no need or TFS is unable to do so. In the next few posts I am going to give examples of each.
Personally, I like to create a separate build for each databases, SSIS and SSRS.
Depending on how tightly coupled your databases are, you may want to build them together or keep them in separate builds. Below I am building 2 database projects together. I then copy the files to a location I will use for the release.