blog.bartekr.net/2017/05/03/what-happens-during-ssis-deployments

Preview meta tags from the blog.bartekr.net website.

Linked Hostnames

9

Thumbnail

Search Engine Appearance

Google

https://blog.bartekr.net/2017/05/03/what-happens-during-ssis-deployments

What happens during SSIS deployments?

When you deploy SSIS project basically you have two options - right click on project name and standalone tool (let’s skip SMO and stuff). Both mean the same: IsDeploymentWizard.exe. I was curious what happens during deployment and why mode/Silent finishes deployment very quickly, so I started digging.\nFirst I prepared sample SSIS project. Nothing extraordinary - just 5 packages, 6 project parameters and no connection managers (who needs them anyway?). Each package contained empty Data Flow Task - so you see that all just to compile something more than a single package. Later during tests, I added connection managers, but they were treated the same as project parameters, so I skipped them (the same with package parameters). To observe the environment I used good old SQL Profiler and Process Explorer.\n



Bing

What happens during SSIS deployments?

https://blog.bartekr.net/2017/05/03/what-happens-during-ssis-deployments

When you deploy SSIS project basically you have two options - right click on project name and standalone tool (let’s skip SMO and stuff). Both mean the same: IsDeploymentWizard.exe. I was curious what happens during deployment and why mode/Silent finishes deployment very quickly, so I started digging.\nFirst I prepared sample SSIS project. Nothing extraordinary - just 5 packages, 6 project parameters and no connection managers (who needs them anyway?). Each package contained empty Data Flow Task - so you see that all just to compile something more than a single package. Later during tests, I added connection managers, but they were treated the same as project parameters, so I skipped them (the same with package parameters). To observe the environment I used good old SQL Profiler and Process Explorer.\n



DuckDuckGo

https://blog.bartekr.net/2017/05/03/what-happens-during-ssis-deployments

What happens during SSIS deployments?

When you deploy SSIS project basically you have two options - right click on project name and standalone tool (let’s skip SMO and stuff). Both mean the same: IsDeploymentWizard.exe. I was curious what happens during deployment and why mode/Silent finishes deployment very quickly, so I started digging.\nFirst I prepared sample SSIS project. Nothing extraordinary - just 5 packages, 6 project parameters and no connection managers (who needs them anyway?). Each package contained empty Data Flow Task - so you see that all just to compile something more than a single package. Later during tests, I added connection managers, but they were treated the same as project parameters, so I skipped them (the same with package parameters). To observe the environment I used good old SQL Profiler and Process Explorer.\n

  • General Meta Tags

    11
    • title
      What happens during SSIS deployments?
    • charset
      utf-8
    • viewport
      width=device-width, initial-scale=1
    • description
      When you deploy SSIS project basically you have two options - right click on project name and standalone tool (let’s skip SMO and stuff). Both mean the same: IsDeploymentWizard.exe. I was curious what happens during deployment and why mode/Silent finishes deployment very quickly, so I started digging.\nFirst I prepared sample SSIS project. Nothing extraordinary - just 5 packages, 6 project parameters and no connection managers (who needs them anyway?). Each package contained empty Data Flow Task - so you see that all just to compile something more than a single package. Later during tests, I added connection managers, but they were treated the same as project parameters, so I skipped them (the same with package parameters). To observe the environment I used good old SQL Profiler and Process Explorer.\n
    • article:section
      Post

  • Open Graph Meta Tags

    6
    • og:title
      What happens during SSIS deployments?
    • og:description
      When you deploy SSIS project basically you have two options - right click on project name and standalone tool (let’s skip SMO and stuff). Both mean the same: IsDeploymentWizard.exe. I was curious what happens during deployment and why mode/Silent finishes deployment very quickly, so I started digging.\nFirst I prepared sample SSIS project. Nothing extraordinary - just 5 packages, 6 project parameters and no connection managers (who needs them anyway?). Each package contained empty Data Flow Task - so you see that all just to compile something more than a single package. Later during tests, I added connection managers, but they were treated the same as project parameters, so I skipped them (the same with package parameters). To observe the environment I used good old SQL Profiler and Process Explorer.\n
    • og:url
      https://blog.bartekr.net/2017/05/03/what-happens-during-ssis-deployments/
    • og:site_name
      BartekR
    • og:type
      article

  • Twitter Meta Tags

    4
    • twitter:title
      What happens during SSIS deployments?
    • twitter:description
      When you deploy SSIS project basically you have two options - right click on project name and standalone tool (let’s skip SMO and stuff). Both mean the same: IsDeploymentWizard.exe. I was curious what happens during deployment and why mode/Silent finishes deployment very quickly, so I started digging.\nFirst I prepared sample SSIS project. Nothing extraordinary - just 5 packages, 6 project parameters and no connection managers (who needs them anyway?). Each package contained empty Data Flow Task - so you see that all just to compile something more than a single package. Later during tests, I added connection managers, but they were treated the same as project parameters, so I skipped them (the same with package parameters). To observe the environment I used good old SQL Profiler and Process Explorer.\n
    • twitter:card
      summary_large_image
    • twitter:image
      https://blog.bartekr.net/2017/05/03/what-happens-during-ssis-deployments/images/internal.get_project_internal.png

  • Link Tags

    5
    • canonical
      https://blog.bartekr.net/2017/05/03/what-happens-during-ssis-deployments/
    • shortcut icon
      /favicon.ico
    • stylesheet
      /scss/style.min.e8c7fca7d1c9294aa7a4f3426c225ee26540f7d94e39be0b5a4a5c8a49ca5a25.css
    • stylesheet
      https://cdn.jsdelivr.net/npm/[email protected]/dist/default-skin/default-skin.min.css
    • stylesheet
      https://cdn.jsdelivr.net/npm/[email protected]/dist/photoswipe.min.css

Links

24