The package was written in Visual Studio, and I can successfully execute the package there. However, when I run the package from SQL it fails with the below context. I do not have access to AWS; I am provided with keys. I don't think that should matter though, since clearly the keys are correct, as files are successfully uploaded when executed in Visual Studio. I also contacted Cozyroc, which indicated the issue wasn't with Cozyroc, since the package successfully executes in Visual Studio. As such, Cozyroc's position is one I am inclined to agree with. This package used to function fine as a job in SSIS, but stopped working when I updated the package with new keys from AWS and deployed a new package. That was back in August. I have whittled this down to either being an issue with the server environment (maybe my IT pushed out an update and it messed something up) or with SQL Server Integration Services. Any help would be appreciated.
Messages > Error Context
on *** at 3/25/2022 2:41:01 PM
The report shows the context for an error.
Error Message:
Upload File Amazon S3 Task:Error: An error occurred with the following error message: "The request signature we calculated does not match the signature you provided. Check your key and signing method.".
Execution Information
Operation ID 89099
Package VWBH\VWBH\VWBH_UploadToS3.dtsx
Environment -
Status Failed
Duration (sec) 3.936
Start Time 3/25/2022 12:23:28 PM
End Time 3/25/2022 12:23:32 PM
Caller AS***
Filter:
Context Depth: 1; (2 more)
Connection Managers
Package Path Context Source Name Property Name Property Value Context Depth
Variables
Package Path Context Source Name Property Name Property Value
All Context Information
Package Path Context Source Name Property Name Property Value Context Depth
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task AccessPolicy 0 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Action 0 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task AmazonS3Connection AmazonS3Connection 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Bucket 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ContentType application/octet-stream 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task CreationName CozyRoc.SqlServer.SSIS.AmazonS3Task, CozyRoc.SSISPlus.2017, Version=1.0.0.0, Culture=neutral, PublicKeyToken=*** 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task DebugMode False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task DelayValidation False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Description Amazon S3 Task 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Disable False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task DisableEventHandlers False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ExecutionDuration 0 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ExecutionResult 0 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ExecutionStatus 3 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ExecutionValue 0 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ExtendedRemoteFileInfo True 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task FailPackageOnFailure False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task FailParentOnFailure False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Filter 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ForcedExecutionValue 0 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ForceExecutionResult -1 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ForceExecutionValue False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task ID {28684062-19EE-47A6-BF44-549850EEBF57} 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task IncludeSubfolders False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task IsDefaultLocaleID True 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task IsFilterVariable False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task IsLocalVariable False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task IsolationLevel 1048576 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task IsRemoteVariable False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task IsRemoteWildcard True 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Local UploadFile 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task LocaleID 1033 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task LoggingMode 0 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task MaximumErrorCount 1 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Name Upload File Amazon S3 Task 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task NoFilesFail True 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task NoRemoteFilesFail True 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Remote /adobe-analytics-mta/VW/ 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Result 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task StartTime 3/25/2022 12:23:30 PM 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task StopOnFailure True 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task StopTime 3/25/2022 12:23:29 PM 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task SuspendRequired False 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task TargetServerVersion 140 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task TaskDescription Provides actions for working with the Amazon S3 service. You can upload, download files or manage the folder structure. 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task TaskDisplayName Amazon S3 Task 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task TransactionOption 1 1
\Package\Upload Files to Amazon S3\Upload File Amazon S3 Task Upload File Amazon S3 Task Version 0 1