Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003"
- DefaultTargets="SSISDeploy">
- <!--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-->
- <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>..\..\$(SOLUTION)\$(SSISProj)\bin\$(CONFIGURATION)\$(SSISProj).ispac</ISPac>
- </PropertyGroup>
- <DeployProjectToCatalogTask
- DeploymentFile="$(ISPac)"
- Instance="$(SSISServer)"
- Folder="$(PROJECTNAME)"
- CreateFolder="true"/>
- <Exec Condition=" '$(SqlServer)' != '' " Command="sqlcmd.exe -b -S $(SqlServer) -i $(MSBuildProjectDirectory)\AlterSSISParameterConnectionManagerDefaults.sql -d SSISDB -v Mailbox="$(Mailbox)" -v Mailbox01Inbox="$(Mailbox01Inbox)" -v Mailbox02Processing="$(Mailbox02Processing)" -v Mailbox03Completed="$(Mailbox03Completed)" -v Mailbox04Error="$(Mailbox04Error)" -v Mailbox05Archive="$(Mailbox05Archive)" -v Axway01Inbound="$(Axway01Inbound)" -v Axway02Outbound="$(Axway02Outbound)" -v PM_APPHostInstance="$(PM_APPHostInstance)" -v PM_STGHostInstance="$(PM_STGHostInstance)" -v PM_EDWHostInstance="$(PM_EDWHostInstance)" -v PM_ETLHostInstance="$(PM_ETLHostInstance)" -v Axway="$(Axway)"" />
- </Target>
- </Project>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement