Geek Answers Handbook

How can I build SSIS and SSRS projects in a city team?

Runner Type: Visual Studio (sln)
Visual Studio: Visual Studio 2008
Objectives: rebuild
Configuration: Development
Platform: default

-------------------------------------------- ------ --------------------------------
For SSIS, there is such a warning:

The project file "SB.SSIS.Package \ SB.SSIS.Package.dtproj" is not supported by MSBuild and cannot be created.

FOR SSRS, here is a warning:

The project file "SB.Report \ SB.Report.rptproj" is not supported by MSBuild and cannot be created.

-------------------------------------------- ------ --------------------------------
When I run the project. It was successful, but there are no files that should be in the trash.

In SSRS, I don’t think I still need this to build, because the .ds and .rdl files are the same and only overloaded in the box. Am I right?

But for SSIS, I think it should be built. Have I forgotten a few steps?

+6
source share
2 answers

Unfortunately, MSBuild does not support the creation of SSIS, SSRS, and SSAS projects out of the box.

You have at least two options for building SSIS, SSRS, SSAS projects in TeamCity:

  • write custom MSBuild script :
    • find the right MSBuild task that can create these types of projects (for example, you can find http://www.msbuildextensionpack.com/ ) or write your own task
    • write a custom MSBuild script that uses the task and places it in the original control
    • add MSBuild build step to create configuration in TeamCity
  • use devenv.com :
    • install SQL Server Business Intelligence Development Studio to create an agent (BI-studio can create them, but normal Visual Studio cannot)
    • add command line build step
      • Executable file:% VS2008_Path% \ devenv.com
      • Command Options: MySolution.sln / rebuild Release
    • Artifact path, for example:
      • SSAS: MyProject \ bin \ *. asdatabase
      • SSIS: MyProject \ bin \ *. dtsx
      • SSRS: MyProject \ bin \ *. rdl

% VSxxxx_Path% is the agent parameter that TeamCity automatically creates when it detects a Visual Studio installation for build agents (for example,% VS2008_Path% or% VS2010_Path%).

PS I think you're right that you do not need to create SSRS projects.

+9
source

In SSRS, I don’t think I still need this to create the cause .ds and .rdl files still remain unchanged and only intersect in the trash. Am i right?

No, it is not. In the latest versions of Visual Studio, rdl files will only work with SQL Server 2016 and work with other versions. you need to build a project and use rdl files from bin \ Debug to use them with SSRS services older than this

0
source

More articles:


All Articles