Run SSIS package in SQL server or run SSIS package in command line use dtexec

0

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
sql-server
ssis
asked on Super User Aug 2, 2019 by hahaha8818 • edited Aug 8, 2019 by Ramhound

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0