Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="Windows-1252"?>
- <Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003"
- DefaultTargets="SSISBuild;SSISDeploy">
- <!--Requires a property called $(SSISProj) to be defined when this script is called-->
- <UsingTask TaskName="DeploymentFileCompilerTask" AssemblyFile="$(VS100COMNTOOLS)\..\IDE\PrivateAssemblies\Microsoft.SqlServer.IntegrationServices.Build.dll" />
- <Target Name="SSISBuild" Condition="'$(SSISProj)' != ''">
- <PropertyGroup>
- <SSISProjPath>..\$(SSISProj)\$(SSISProj).dtproj</SSISProjPath>
- </PropertyGroup>
- <Message Text="**************Building SSIS project: $(SSISProjPath) for configuration: $(CONFIGURATION)**************" />
- <DeploymentFileCompilerTask
- InputProject="$(SSISProjPath)"
- Configuration="$(CONFIGURATION)"
- ProtectionLevel="DontSaveSensitive">
- </DeploymentFileCompilerTask>
- </Target>
- <UsingTask TaskName="DeployProjectToCatalogTask" AssemblyFile="$(VS100COMNTOOLS)\..\IDE\PrivateAssemblies\Microsoft.SqlServer.IntegrationServices.Build.dll" />
- <Target Name="SSISDeploy" Condition="'$(SSISProj)' != ''">
- <Message Text="**************Publishing SSIS project: $(SSISProj) to: $(SSISServer) to folder: $(PROJECTNAME)**************" />
- <PropertyGroup>
- <ISPac>..\$(SSISProj)\bin\$(CONFIGURATION)\$(SSISProj).ispac</ISPac>
- </PropertyGroup>
- <DeployProjectToCatalogTask
- DeploymentFile="$(ISPac)"
- Instance="$(SSISServer)"
- Folder="$(PROJECTNAME)"
- CreateFolder="true"/>
- </Target>
- </Project>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement