Move file to Azure blob storage using Powershell script in VS2008

Supriya Gupta 21

HI
I have powershell script which is used to upload file in Azure blob storage. The powershell script on its own is working fine. But when i try to call the script using Execute Process task in VS2008, the package runs fine without any error but the file is not being moved. to Azure blob storage
The command being used in Execute Process Task Arguments is :

-File "C:\PSAzureSSIS\ExportFile.ps1"

When i run the package it opens chrome and asks me to select the account to sign-in and once i select the account the control shifts back to pacakge and completes successfuly but the file is not moved. Same happens when i execute the powershell on its own, but the file actually gets moved to Azure blob storage. What am i missing ?
Thanks

deherman-MSFT 35,316 Reputation points Microsoft Employee

2020-11-19T16:42:14.41+00:00

@Supriya Gupta
Can you share the PowerShell script that you are running? Also can you try to execute it in Visual Studio Code or a newer version of Visual Studio? Visual Studio 2008 has reached end of life and is no longer supported.
Supriya Gupta 21 Reputation points

2020-11-19T21:13:10.993+00:00

please see the code in image attached. yes i know 2008 is no more supported but still we have to go with it. This code is working fine on its own when executed as poweshell script but when i execute it from ssis it does not work. Your help is much appreciated.
Supriya Gupta 21 Reputation points

2020-11-19T21:40:13.737+00:00

I tried in VS2012, but the same thing is happening meaning file is not getting moved to container in blob storage. It takes me to the authentication page in web explorer (though i do not want this to happen either), i select my account and then package execution completes successfully in few seconds but the file does not get moved.
When i say code execution from powershell is working fine, i am executing it from Visual studio code only.

Accepted answer

deherman-MSFT 35,316 Reputation points Microsoft Employee

2020-11-19T22:26:53.43+00:00

@Supriya Gupta
AzCopy is not part of PowerShell which is probably why it works when you run the script locally but not from VS. Since you are using PowerShell I recommend using Set-AzStorageBlobContent to upload the blob. You also might find this Stack Overflow thread helpful.

-------------------------------

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Please sign in to rate this answer.

1 person found this answer helpful.
Supriya Gupta 21 Reputation points

2020-11-19T23:26:48.667+00:00

I am glad it worked. Can you also help me with one more thing. when executed as part of poweshell or SSIS the web browser opens up and i have to select my account name and that's how my azure account gets validated and then it proceeds with the blob storage upload. I do not want this to happen when ssis is executed. Am i missing mentioning some credentials in my script so that no more authentication is required.

deherman-MSFT 35,316 Reputation points Microsoft Employee

2020-11-20T00:01:18.65+00:00

@Supriya Gupta
I am not exactly sure the end goal, but if you simply want to upload a blob then lots of the code is unnecessary. Connect-AzAccount is why you are being prompted to login, but if you are using the Storage Account Key it is not necessary. Something as simple as below would work:

$name = "" $container = "" $file = "" $key = "" $context = New-AzStorageContext -StorageAccountName $name -StorageAccountKey $key Set-AzStorageBlobContent -Context $context -Container $container -File $file

Supriya Gupta 21 Reputation points

2020-11-20T00:46:06.193+00:00

great , if i remove it's working. Well Appreciated.
Sign in to comment

Share via

Move file to Azure blob storage using Powershell script in VS2008

0 additional answers