Azure DevOps SSIS Build task doesn't produce dtsconfig file

%3CLINGO-SUB%20id%3D%22lingo-sub-2926007%22%20slang%3D%22en-US%22%3EAzure%20DevOps%20SSIS%20Build%20task%20doesn't%20produce%20dtsconfig%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2926007%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%203%20dtsx%20packages%20(package%20deployment%20model)%20that%20are%20now%20being%20locally%20built%20in%20VisualStudio%202019%20.%3C%2FP%3E%3CP%3EThis%20process%20produces%20the%203%20files%20inside%20the%20bin%2Fdeployment%20folder%2C(.deploymentManifest%2C%20.dtsx%20and%20.dtsconfig)%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%2C%20needed%20to%20install%20and%20configure%20the%20job%20steps%20%3A%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Z5KHT%22%20style%3D%22width%3A%20271px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324180iD29BF3AA0A8AAC7D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Z5KHT%22%20alt%3D%22Z5KHT%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20pipeline%20job%20builds%20it%20in%20a%20similar%20way%20using%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Enuget%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3ESSIS%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EBuild%20task.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fi.stack.imgur.com%2FfO2AQ.png%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22fO2AQ%22%20style%3D%22width%3A%20860px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324181i88686529C66A2106%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22fO2AQ%22%20alt%3D%22fO2AQ%22%20%2F%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fi.stack.imgur.com%2FfO2AQ.png%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20doesn%E2%80%99t%20produce%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Edtsconfig%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efile%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fi.stack.imgur.com%2F94ARB.png%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%2294ARB%22%20style%3D%22width%3A%20378px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324182i7108CBCAB415F3AC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%2294ARB%22%20alt%3D%2294ARB%22%20%2F%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EI've%20tried%20using%20environment%20variables%20in%20package%20configuration%20with%20the%20same%20result.%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%E2%80%99ve%20tried%20using%20relative%20path%20and%20copying%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Edtsconfig%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Einto%20the%20folder%20but%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EdeploymentManifest%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efile%20just%20don%E2%80%99t%20have%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EConfigurationFile%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Etag.%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22%22%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eversion%3D%221.0%22%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eencoding%3D%22UTF-8%22%3F%26gt%3B%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22%22%3E%3CDTSDEPLOYMENTMANIFEST%3E%3C%2FDTSDEPLOYMENTMANIFEST%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EGeneratedBy%3D%22WIN-1V2BO1VIS10%5CVssAdministrator%22%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EGeneratedFromProjectName%3D%22ETL%22%3C%2FSPAN%3E%0A%20%3CSPAN%20class%3D%22%22%3EGeneratedDate%3D%222021-10-14T16%3A21%3A19.2937202%2B00%3A00%22%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EAllowConfigurationChanges%3D%22true%22%26gt%3B%3C%2FSPAN%3E%20%0A%3CSPAN%20class%3D%22%22%3E%3CPACKAGE%3EPopulate_DW_XX.dtsx%3C%2FPACKAGE%3E%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22%22%3E%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%20%0A%3CSPAN%20class%3D%22%22%3E%3C%2FSPAN%3E%20%20%3CP%3E%26nbsp%3B%3C%2FP%3E
Occasional Visitor

I have 3 dtsx packages (package deployment model) that are now being locally built in VisualStudio 2019 .

This process produces the 3 files inside the bin/deployment folder,(.deploymentManifest, .dtsx and .dtsconfig) , needed to install and configure the job steps :

 

Z5KHT

The pipeline job builds it in a similar way using nuget and SSIS Build task.

fO2AQ

 

 

But doesn’t produce the dtsconfig file

94ARB

I've tried using environment variables in package configuration with the same result. 

 

I’ve tried using relative path and copying the dtsconfig into the folder but the deploymentManifest file just don’t have the ConfigurationFile tag.

<?xml version="1.0" encoding="UTF-8"?>
<DTSDeploymentManifest GeneratedBy="WIN-1V2BO1VIS10\VssAdministrator" GeneratedFromProjectName="ETL"
 GeneratedDate="2021-10-14T16:21:19.2937202+00:00" AllowConfigurationChanges="true"> 
<Package>Populate_DW_XX.dtsx
</Package> 
</DTSDeploymentManifest>  

 

0 Replies