A Python package for validating SQL Server Integration Services (SSIS) packages
Project description
ssis_validator
A Python package for validating SQL Server Integration Services (SSIS) projects. It can be used as a part of Continuous Integration pipeline.
This Python application is written for Python 3.7+.
Install
This package is available on PyPi package repository. You can install it like below:
pip install ssis_validator
Usage
1. Projects
Specify one or multiple --project
arguments and provide the full path to the SSIS Projects that you want to validate.
ssis_validator --project Project_1 --project Project_2
2. Repository Staging
Specify --repository
optional argument along with one --project
argument passing the Git repository hosting multiple SSIS Projects. The validator only checks SSIS projects that are staged.
ssis_validator --project Project_1 --repository
Validation Criteria
The following validation criteria are currently checked. The current version has the accepted specifications hard-coded. The next version will parameterize all of them in a configuration file.
Project
- Project Server Version:
SQLServer2014
,SQLServer2016
- Project Protection Level:
EncryptSensitiveWithPassword
- Packages Presence in Project:
True
- Linkage of Packages:
True
- Project Deployment Model:
Project
Package
- Package Last Modified Visual Studio Version:
SSIS_2016
- Package Protection Level:
EncryptSensitiveWithPassword
- (Optional) PragmaticWorks BIxPress Server Name:
server_name
- (Optional) PragmaticWorks BIxPress Continue Execution on Error:
True
- (Optional) PragmaticWorks BIxPress Reporting of Error on Failure:
False
Contribution
See an area for improvement, please open an issue or send a PR.
Future Improvements
- mypy type hints
- add configuration file
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for ssis_validator-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0ac789c0c3ba3e4a957bc5ea4fcc716333ba513f948305364786c99cce085cd1 |
|
MD5 | 72712a7826286790884604db3cd1438b |
|
BLAKE2b-256 | 89f492be86041fabd116172ac1749fad437673e8e60fffed36dfcea5e5611ae3 |