All,
I have troubles with running SSIS package in either SQL server or in command line use dtexec. I can run the SSIS package successfully in visual studio 2017. But when I deployed in SQL server under SSIS catalog, I can't run the package successfully. The package I created is a very simple SSIS package only contain one script task inside.
I have tried many ways, but still, don't work. Please help me. Thank you.
Here is the output when running in the command line:
Started: 12:31:43 PM
Warning: 2019-08-02 12:31:44.51
Code: 0xC0016016
Source: SSIS:Property
Description: Failed to decrypt an encrypted XML node. Verify that the project was created by the same user. Project load will attempt to continue without the encrypted information.
End Warning
Warning: 2019-08-02 12:31:44.51
Code: 0x800190FF
Source:
Description: Failed to decrypt sensitive data in a project with a user key. You may not be the user who encrypted this project, or you are not using the same machine that was used to save the project. If the sensitive data is a parameter value, the value may be required to run the package on the Integration Services server.
End Warning
Error: 2019-08-02 12:31:45.79
Code: 0x00000001
Source: Script Task
Description: Exception has been thrown by the target of an invocation.
End Error
Warning: 2019-08-02 12:31:45.79
Code: 0x80019002
Source: Package
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 12:31:43 PM
Finished: 12:31:45 PM
Elapsed: 1.875 seconds
User contributions licensed under CC BY-SA 3.0