This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Programming › .Net/C # › SSIS Tutorial (7) SQL Server 2012 Executing SSIS Jobs ...
View: 26814|Reply: 0

[Source] SSIS Tutorial (7) SQL Server 2012 Executes SSIS Jobs

[Copy link]
Posted on 8/2/2020 7:25:30 PM | | | |
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

SSIS Tutorial (5) Executing SSIS Packages with DTEXEC
https://www.itsvse.com/thread-9339-1-1.html

SSIS Tutorial (6) Using SSIS Package XML Configuration Files
https://www.itsvse.com/thread-9340-1-1.html
Copy the ssis package Package.dtsx and the xml configuration file database.dtsConfig to a directory on the server. (The catalog can be created according to your own situation)

I copied the two files to the server E:\ssis_package directory, which will be used below.

First, modify the database.dtsConfig configuration file and fill in the configuration information for the production environment. (omitted)

Again, use notepad++ to modify the Package.dtsx package file, modify the DTS:ConfigurationString path under the DTS:Configuration node, and after the modification is completed, it is as follows:

Try to use the server DTExecUI test execution, and it can be executed successfully, as shown in the image below:



When SqlServer is turned on, the default proxy service is not enabled



Open the SqlServer configuration manager and start the corresponding agent instance



Go back to the SqlServer Manager and start the SQL Server agent.

Right-click Job—Create a new job





Select Step - Add Step, Type Select SSIS Package, Select Package Source: File System in General



Select Schedule - Create a new job plan and execute it once a day at 1 a.m., as shown in the following figure:



A simple SqlServer scheduled task is created, try to right-click to select the "Job Start Step" test, as shown in the following figure:



Our SSIS package can be executed normally.

(End)





Previous:SSIS Tutorial (6) Using SSIS Package XML Configuration Files
Next:ASP.NET Allows cross-domain OPTIONS requests

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com