SHARE
TWEET

msbuild script for building and deploying a SSIS .ispac file

a guest Jun 27th, 2012 2,648 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?xml version="1.0" encoding="Windows-1252"?>
  2. <Project  xmlns="http://schemas.microsoft.com/developer/msbuild/2003"
  3.          DefaultTargets="SSISBuild;SSISDeploy">
  4.   <!--Requires a property called $(SSISProj) to be defined when this script is called-->
  5.   <UsingTask TaskName="DeploymentFileCompilerTask" AssemblyFile="$(VS100COMNTOOLS)\..\IDE\PrivateAssemblies\Microsoft.SqlServer.IntegrationServices.Build.dll" />
  6.   <Target Name="SSISBuild" Condition="'$(SSISProj)' != ''">
  7.     <PropertyGroup>
  8.       <SSISProjPath>..\$(SSISProj)\$(SSISProj).dtproj</SSISProjPath>
  9.     </PropertyGroup>
  10.     <Message Text="**************Building SSIS project: $(SSISProjPath) for configuration: $(CONFIGURATION)**************" />
  11.     <DeploymentFileCompilerTask
  12.      InputProject="$(SSISProjPath)"
  13.      Configuration="$(CONFIGURATION)"
  14.      ProtectionLevel="DontSaveSensitive">
  15.     </DeploymentFileCompilerTask>
  16.   </Target>
  17.  
  18.  
  19.  
  20.   <UsingTask TaskName="DeployProjectToCatalogTask" AssemblyFile="$(VS100COMNTOOLS)\..\IDE\PrivateAssemblies\Microsoft.SqlServer.IntegrationServices.Build.dll" />
  21.   <Target Name="SSISDeploy" Condition="'$(SSISProj)' != ''">
  22.     <Message Text="**************Publishing SSIS project: $(SSISProj) to: $(SSISServer) to folder: $(PROJECTNAME)**************" />
  23.     <PropertyGroup>
  24.       <ISPac>..\$(SSISProj)\bin\$(CONFIGURATION)\$(SSISProj).ispac</ISPac>
  25.     </PropertyGroup>
  26.     <DeployProjectToCatalogTask
  27.          DeploymentFile="$(ISPac)"
  28.          Instance="$(SSISServer)"
  29.          Folder="$(PROJECTNAME)"
  30.          CreateFolder="true"/>
  31.   </Target>
  32. </Project>
RAW Paste Data
Top