blog.bartekr.net/2018/04/13/testing-database-connections-with-ssisunit
Preview meta tags from the blog.bartekr.net website.
Linked Hostnames
6- 21 links toblog.bartekr.net
- 3 links togithub.com
- 1 link tobrinf.wordpress.com
- 1 link togohugo.io
- 1 link tojimmycai.com
- 1 link tox.com
Thumbnail

Search Engine Appearance
Testing database connections with ssisUnit
Previously we successfully prepared tests for variables and parameters using VariableCommandand and ParameterCommand. Now it’s time to communicate with the database, and for that, I will use connection manager defined on the project level. I know from the ssisUnit tutorials it works perfect with package connection managers, so it’s time to verify it against the projects. I will test the package 10_ProjectCM.dtsx - it is just getting a single value from the table in a database and storing it in a variable. All the packages and unit tests are on my GitHub.\n
Bing
Testing database connections with ssisUnit
Previously we successfully prepared tests for variables and parameters using VariableCommandand and ParameterCommand. Now it’s time to communicate with the database, and for that, I will use connection manager defined on the project level. I know from the ssisUnit tutorials it works perfect with package connection managers, so it’s time to verify it against the projects. I will test the package 10_ProjectCM.dtsx - it is just getting a single value from the table in a database and storing it in a variable. All the packages and unit tests are on my GitHub.\n
DuckDuckGo
Testing database connections with ssisUnit
Previously we successfully prepared tests for variables and parameters using VariableCommandand and ParameterCommand. Now it’s time to communicate with the database, and for that, I will use connection manager defined on the project level. I know from the ssisUnit tutorials it works perfect with package connection managers, so it’s time to verify it against the projects. I will test the package 10_ProjectCM.dtsx - it is just getting a single value from the table in a database and storing it in a variable. All the packages and unit tests are on my GitHub.\n
General Meta Tags
9- titleTesting database connections with ssisUnit
- charsetutf-8
- viewportwidth=device-width, initial-scale=1
- descriptionPreviously we successfully prepared tests for variables and parameters using VariableCommandand and ParameterCommand. Now it’s time to communicate with the database, and for that, I will use connection manager defined on the project level. I know from the ssisUnit tutorials it works perfect with package connection managers, so it’s time to verify it against the projects. I will test the package 10_ProjectCM.dtsx - it is just getting a single value from the table in a database and storing it in a variable. All the packages and unit tests are on my GitHub.\n
- article:sectionPost
Open Graph Meta Tags
6- og:titleTesting database connections with ssisUnit
- og:descriptionPreviously we successfully prepared tests for variables and parameters using VariableCommandand and ParameterCommand. Now it’s time to communicate with the database, and for that, I will use connection manager defined on the project level. I know from the ssisUnit tutorials it works perfect with package connection managers, so it’s time to verify it against the projects. I will test the package 10_ProjectCM.dtsx - it is just getting a single value from the table in a database and storing it in a variable. All the packages and unit tests are on my GitHub.\n
- og:urlhttps://blog.bartekr.net/2018/04/13/testing-database-connections-with-ssisunit/
- og:site_nameBartekR
- og:typearticle
Twitter Meta Tags
4- twitter:titleTesting database connections with ssisUnit
- twitter:descriptionPreviously we successfully prepared tests for variables and parameters using VariableCommandand and ParameterCommand. Now it’s time to communicate with the database, and for that, I will use connection manager defined on the project level. I know from the ssisUnit tutorials it works perfect with package connection managers, so it’s time to verify it against the projects. I will test the package 10_ProjectCM.dtsx - it is just getting a single value from the table in a database and storing it in a variable. All the packages and unit tests are on my GitHub.\n
- twitter:cardsummary_large_image
- twitter:imagehttps://blog.bartekr.net/2018/04/13/testing-database-connections-with-ssisunit/images/PackageOutline.png
Link Tags
5- canonicalhttps://blog.bartekr.net/2018/04/13/testing-database-connections-with-ssisunit/
- shortcut icon/favicon.ico
- stylesheet/scss/style.min.e8c7fca7d1c9294aa7a4f3426c225ee26540f7d94e39be0b5a4a5c8a49ca5a25.css
- stylesheethttps://cdn.jsdelivr.net/npm/[email protected]/dist/default-skin/default-skin.min.css
- stylesheethttps://cdn.jsdelivr.net/npm/[email protected]/dist/photoswipe.min.css
Links
28- http://blog.bartekr.net/2018/03/26/writing-first-tests-with-ssisunit
- https://blog.bartekr.net
- https://blog.bartekr.net/2017/12/24/upgrading-ssis-projects-part-i
- https://blog.bartekr.net/2018/02/04/upgrading-ssis-projects-part-ii
- https://blog.bartekr.net/2018/02/28/upgrading-ssis-projects-part-iii