{ "info": { "author": "Mike Hosseini", "author_email": "mahdihosseini75@gmail.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.7" ], "description": "# ssis_validator\n\nA Python package for validating SQL Server Integration Services (SSIS) projects. It can be used as a part of Continuous Integration pipeline.\n\nThe module works by parsing the XML content of SSIS Projects and Packages while handling all the rough edges. It identifies the configurations of the projects and validates whether they meet the specifications.\n\nThis Python application is written for Python 3.7+.\n\n## Install\n\nThis package is available on [PyPi](https://pypi.org/project/ssis-validator/) package repository. You can install it like below:\n\n```bash\npip install ssis_validator\n```\n\n## Usage\n\n### 1. Projects\n\nSpecify one or multiple `--project` arguments and provide the full path to the SSIS Projects that you want to validate.\n\n```bash\nssis_validator --project Project_1 --project Project_2\n```\n\n### 2. Repository Staging\n\nSpecify `--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.\n\n\n```bash\nssis_validator --project Project_1 --repository\n```\n\n## Validation Criteria\n\nThe 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.\n\n### Project\n\n1. Project Server Version: `SQLServer2014`, `SQLServer2016`\n2. Project Protection Level: `EncryptSensitiveWithPassword`\n3. Packages Presence in Project: `True`\n4. Linkage of Packages: `True`\n5. Project Deployment Model: `Project`\n\n### Package\n\n1. Package Last Modified Visual Studio Version: `SSIS_2016`\n2. Package Protection Level: `EncryptSensitiveWithPassword`\n3. (Optional) PragmaticWorks BIxPress Server Name: `server_name`\n4. (Optional) PragmaticWorks BIxPress Continue Execution on Error: `True`\n5. (Optional) PragmaticWorks BIxPress Reporting of Error on Failure: `False`\n\n## Contribution\n\nSee an area for improvement, please open an issue or send a PR.\n\n## Future Improvements\n\n- [ ] mypy type hints\n- [ ] add configuration file\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/mahdi-hosseini/ssis_validator", "keywords": "", "license": "MIT", "maintainer": "Mike Hosseini", "maintainer_email": "mahdihosseini75@gmail.com", "name": "ssis-validator", "package_url": "https://pypi.org/project/ssis-validator/", "platform": "", "project_url": "https://pypi.org/project/ssis-validator/", "project_urls": { "Homepage": "https://github.com/mahdi-hosseini/ssis_validator", "Repository": "https://github.com/mahdi-hosseini/ssis_validator" }, "release_url": "https://pypi.org/project/ssis-validator/0.1.2/", "requires_dist": [ "colorama (>=0.4.1,<0.5.0)", "lxml (>=4.4,<5.0)", "gitpython (>=3.0,<4.0)", "crayons (>=0.2.0,<0.3.0)" ], "requires_python": ">=3.7,<4.0", "summary": "A Python package for validating SQL Server Integration Services (SSIS) packages", "version": "0.1.2" }, "last_serial": 5947645, "releases": { "0.1.1": [ { "comment_text": "", "digests": { "md5": "72712a7826286790884604db3cd1438b", "sha256": "0ac789c0c3ba3e4a957bc5ea4fcc716333ba513f948305364786c99cce085cd1" }, "downloads": -1, "filename": "ssis_validator-0.1.1-py3-none-any.whl", "has_sig": false, "md5_digest": "72712a7826286790884604db3cd1438b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.7,<4.0", "size": 8777, "upload_time": "2019-10-08T03:37:58", "url": "https://files.pythonhosted.org/packages/89/f4/92be86041fabd116172ac1749fad437673e8e60fffed36dfcea5e5611ae3/ssis_validator-0.1.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e1449028708dfbcf72b362684e546efd", "sha256": "e101d428f610b08dfe4bd398f44d3ca196aa7a0e153ec90cd4b7f78ee8224b29" }, "downloads": -1, "filename": "ssis_validator-0.1.1.tar.gz", "has_sig": false, "md5_digest": "e1449028708dfbcf72b362684e546efd", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.7,<4.0", "size": 8597, "upload_time": "2019-10-08T03:38:01", "url": "https://files.pythonhosted.org/packages/6f/f6/f4a7af7eece04d94018f4ac18fd2ec9ee456e7f9d29ac31e9ae192b077eb/ssis_validator-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "374f01a3290b789d296e95d1c7cb0057", "sha256": "f1c9efd91e5befde5bfdda087528bc3923a7367e68bc58118c2441f88d7555c1" }, "downloads": -1, "filename": "ssis_validator-0.1.2-py3-none-any.whl", "has_sig": false, "md5_digest": "374f01a3290b789d296e95d1c7cb0057", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.7,<4.0", "size": 8974, "upload_time": "2019-10-09T03:53:34", "url": "https://files.pythonhosted.org/packages/44/44/335f1ad0d4c8a959d1a4a14114556e35b67e8f978c002b7a34366d46a785/ssis_validator-0.1.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d727477f1eee7499a56245bc492c0c1e", "sha256": "0dee4b2f908d99b77b8d0da8512ef22f89b4b9b67cbcda77f2ca7ead41103866" }, "downloads": -1, "filename": "ssis_validator-0.1.2.tar.gz", "has_sig": false, "md5_digest": "d727477f1eee7499a56245bc492c0c1e", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.7,<4.0", "size": 8890, "upload_time": "2019-10-09T03:53:35", "url": "https://files.pythonhosted.org/packages/24/33/152567b291c157e890ec0844e61a95a1454a1731988d0b01f6b5d5210fc2/ssis_validator-0.1.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "374f01a3290b789d296e95d1c7cb0057", "sha256": "f1c9efd91e5befde5bfdda087528bc3923a7367e68bc58118c2441f88d7555c1" }, "downloads": -1, "filename": "ssis_validator-0.1.2-py3-none-any.whl", "has_sig": false, "md5_digest": "374f01a3290b789d296e95d1c7cb0057", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.7,<4.0", "size": 8974, "upload_time": "2019-10-09T03:53:34", "url": "https://files.pythonhosted.org/packages/44/44/335f1ad0d4c8a959d1a4a14114556e35b67e8f978c002b7a34366d46a785/ssis_validator-0.1.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d727477f1eee7499a56245bc492c0c1e", "sha256": "0dee4b2f908d99b77b8d0da8512ef22f89b4b9b67cbcda77f2ca7ead41103866" }, "downloads": -1, "filename": "ssis_validator-0.1.2.tar.gz", "has_sig": false, "md5_digest": "d727477f1eee7499a56245bc492c0c1e", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.7,<4.0", "size": 8890, "upload_time": "2019-10-09T03:53:35", "url": "https://files.pythonhosted.org/packages/24/33/152567b291c157e890ec0844e61a95a1454a1731988d0b01f6b5d5210fc2/ssis_validator-0.1.2.tar.gz" } ] }