Run the SSIS package on the SQL Server or run the SSIS package from the command line, use dtexec


All,

I have problems with running the SSIS package in SQL Server or command line, use dtexec. I can run the SSIS package successfully in Visual Studio 2017. But when I was deployed to an SQL server under the SSIS catalog, I can not run the package successfully. The package I created is a very simple SSIS package that contains only one script task.

I've tried a lot of ways but still do not work. Help me, please. Thank you.

Here is the screen capture for the command line runtime:

Started: 12:31:43 PM

Warning: 2019-08-02 12: 31: 44.51

Code: 0xC0016016
Source: SSIS: Property

Description: Unable to decrypt an encrypted XML node. Verify that the project was created by the same user. The loading of the project will try to continue without the encrypted information.
End the warning

Warning: 2019-08-02 12: 31: 44.51
Code: 0x800190FF
Source:

Description: Failed to decrypt sensitive data in the project with a user key. You may not be the user who encrypted this project or you do not use the same computer that was used to save the project. If the sensitive data is a parameter value, this value may be required to run the package on the Integration Services server.
End the warning

Error: 2019-08-02 12: 31: 45.79
Code: 0x00000001
Source: script task

Description: An exception was thrown by the target of a call.
End Error

Warning: 2019-08-02 12: 31: 45.79
Code: 0x80019002
Source: package

Description: SSIS warning code DTS_W_MAXIMUMERRORCOUNTREACHED. The execution method was successful, but the number of errors generated (1) reached the maximum allowed (1); causing failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Modify the MaximumErrorCount or correct errors.
End the warning

DTExec: The package execution returned DTSER_FAILURE (1).
Started: 12:31:43 PM
Ended: 12:31:45 PM
Elapsed time: 1.875 seconds