SSIS deployment issue

Question

Visual Studio 2019 SsisAzureFeaturePack_2017_x86.msi Azure SSISDB I am using the same ispac file in below both scenarios If I use Integration services Deployment Wizard The ispac was execution with our any issue (task in dtsx is just copy azure DB data to azure blob storage) But if I use the PowerShell script to deploy the same ispac, The execution was failed with the below errors ![122698-image.png][1] [1]: /api/attachments/122698-image.png?platform=QnA After deploying I have exported the ispac in both scenarios .... i see the tokens are different. I am sure that I used the same ispac file not sure why the tokens are getting different. Evey deployment of the same ispac i see tokens are different. So, please can anyone help how to get the ispac worked if we deploy via powershell ? Script I used: ----------------------------------------------------- $TargetServerName = "TARGET SERVER" $TargetFolderName = "ISPAC" $ProjectFilePath = "C:\Users\ankasani\Downloads\SampleSSIS.ispac" $ProjectName = "SampleSSIS" $folderDescription = "ISPAC deployment file" [System.Reflection.Assembly]::Load("Microsoft.SQLServer.Management.IntegrationServices, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL") $sqlConnectionString = "Data Source=" + $TargetServerName + ";Initial Catalog=SSISDB;User ID=USER;Password=PASSWORD;" $sqlConnection = New-Object System.Data.SqlClient.SqlConnection $sqlConnectionString $integrationServices = New-Object "Microsoft.SqlServer.Management.IntegrationServices.IntegrationServices" $sqlConnection $catalog = $integrationServices.Catalogs["SSISDB"] $catalogFolder = $catalog.Folders[$TargetFolderName] if (-not $catalogFolder) { Write-Host([System.string]::Format("Creating folder {0}", $TargetFolderName)) $catalogFolder = New-Object "Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder" ($catalog, $TargetFolderName, $folderDescription) $catalogFolder.Create() } else { $catalogFolder.Description = $folderDescription $catalogFolder.Alter() Write-Host([System.string]::Format("Existing folder {0}", $TargetFolderName)) } Write-Host "Deploying " $ProjectName " project ..." [byte[]] $projectFile = [System.IO.File]::ReadAllBytes($ProjectFilePath) $catalogFolder.DeployProject($ProjectName, $projectFile) Write-Host "Done."

Answer 1

Hi anonymous user,

To deploy an SSIS project with PowerShell to Azure DB, you may refer below to see if you miss any steps.

ssis-quickstart-deploy-powershell

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October