SHARE
TWEET

msbuild script for deploying SSIS .ispac files

jamiet Aug 28th, 2012 103 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <Project  xmlns="http://schemas.microsoft.com/developer/msbuild/2003"
  2.          DefaultTargets="SSISDeploy">
  3.   <!--The latest (at the time of writing) source code for Microsoft.SqlServer.IntegrationServices.Build.dll can be found at http://sqlsrvintegrationsrv.codeplex.com/SourceControl/changeset/89858-->
  4.   <UsingTask TaskName="DeployProjectToCatalogTask" AssemblyFile="$(VS100COMNTOOLS)\..\IDE\PrivateAssemblies\Microsoft.SqlServer.IntegrationServices.Build.dll" />
  5.   <Target Name="SSISDeploy" Condition="'$(SSISProj)' != ''">
  6.     <Message Text="**************Publishing SSIS project: $(SSISProj) to: $(SSISServer) to folder: $(PROJECTNAME)**************" />
  7.     <PropertyGroup>
  8.       <ISPac>..\..\$(SOLUTION)\$(SSISProj)\bin\$(CONFIGURATION)\$(SSISProj).ispac</ISPac>
  9.     </PropertyGroup>
  10.     <DeployProjectToCatalogTask
  11.          DeploymentFile="$(ISPac)"
  12.          Instance="$(SSISServer)"
  13.          Folder="$(PROJECTNAME)"
  14.          CreateFolder="true"/>
  15.     <Exec Condition=" '$(SqlServer)' != '' " Command="sqlcmd.exe -b -S $(SqlServer) -i $(MSBuildProjectDirectory)\AlterSSISParameterConnectionManagerDefaults.sql -d SSISDB -v Mailbox=&quot;$(Mailbox)&quot; -v Mailbox01Inbox=&quot;$(Mailbox01Inbox)&quot; -v Mailbox02Processing=&quot;$(Mailbox02Processing)&quot; -v Mailbox03Completed=&quot;$(Mailbox03Completed)&quot; -v Mailbox04Error=&quot;$(Mailbox04Error)&quot; -v Mailbox05Archive=&quot;$(Mailbox05Archive)&quot; -v Axway01Inbound=&quot;$(Axway01Inbound)&quot; -v Axway02Outbound=&quot;$(Axway02Outbound)&quot; -v PM_APPHostInstance=&quot;$(PM_APPHostInstance)&quot; -v PM_STGHostInstance=&quot;$(PM_STGHostInstance)&quot; -v PM_EDWHostInstance=&quot;$(PM_EDWHostInstance)&quot; -v PM_ETLHostInstance=&quot;$(PM_ETLHostInstance)&quot; -v Axway=&quot;$(Axway)&quot;" />
  16.   </Target>
  17. </Project>
RAW Paste Data
Top