SSIS Tutorial (5) Executing SSIS Packages with DTEXEC

Little scum · Posted on 2020-8-2 11:30:21

SSIS Tutorial 1 Introduction to SQL Server Integration Services
https://www.itsvse.com/thread-9257-1-1.html

SSIS Tutorial (2) Visual Studio 2019 (VS2019) Install SSIS
https://www.itsvse.com/thread-9331-1-1.html

SSIS Tutorial (3) Add a MySQL data source
https://www.itsvse.com/thread-9338-1-1.html

SSIS Tutorial 4 Synchronize MySQL Data to a SQL Server Database
https://www.itsvse.com/thread-9336-1-1.html

I created an SSIS project with VS 2019, in VS, you can select the package right-click to execute, as shown in the figure below:

Although the machine can execute SSIS packages through VS, it is impossible for the server to install a VS to execute, and the server can execute through SQL Server.

The database version I have installed locally and on the server is: SQL Server 2017

DTExecUI visualizes execution

You can find "SQL Server 2012" through the start menu, select "Execution Package Utility" to execute, my local path address is:

"D:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\DTExecUI.exe"

Select File System from the package source and try to execute it, but the error is as follows:

Title: SSIS Execution Properties
------------------------------

Error: 2020-08-02 11:19:01.51
Code: 0xC001700A
Source: Package
Note: The version number in the package is invalid. The version number cannot be greater than the current version number.
Error ends
Error: 2020-08-02 11:19:01.53
Code: 0xC0016020
Source: Package
Description: The migration of packages from version 8 to version 6 failed with the error 0xC001700A "The version number in the package is invalid." The version number cannot be greater than the current version number. ”。
Error ends
Error: 2020-08-02 11:19:01.60
Code: 0xC0010018
Source: Package
Description: An error occurred when loading the value "<DTS:Property xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:Name="PackageFormatVersion">8</DTS:Property>" from the node "DTS:Property".
Error ends
Unable to load package "C:\Users\itsvse_pc\source\repos\ITSVSE" due to error 0xC0010014. ForumThreadSynchronization\ITSVSE. ForumThreadSynchronization\Package.dtsx”。
Explanation: One or more errors occurred due to error 0xC0010014". This message should be preceded by more specific error messages detailing these errors. This message is used as a return value for the function that encounters the error. , the package could not be loaded. This occurs when CPackage::LoadFromXML fails.
Source: Package

------------------------------
Button:

Are you sure
------------------------------

The reason for the error is that the SSIS package version is too high, and we need to downgrade the execution, right-click the properties of the SSIS project and select the appropriate version, as shown in the figure below:

Try executing the ssis package again with the following success:

DTExec command line execution

DTEXEC. EXE is located in the installation directory of SQL Server, and you can specify the dtsx package file to run the package or run the package that has been deployed to SQL Server, such as through the following command:

Login is visible.

DTEXEC.EXE Directory address:

"D:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTExec.exe"

Try to do it as shown below:

(End)

[Source] SSIS Tutorial (5) Executing SSIS Packages with DTEXEC

Related Posts

Sections viewed