SSIS Deployments with SQL Server 2012

Question

SSIS Deployments with SQL Server 2012

Koen Verbeeck

SSC Guru

Points: 259115
More actions
August 15, 2013 at 12:03 am

#276275

Comments posted to this topic are about the item SSIS Deployments with SQL Server 2012
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

mtassin SSC-Insane Points: 23099 More actions · Answer 1

Hey Koen,

Nice article. I hope you'll at some point discuss the headaches of managing the execution logs of projects deployed to SSISDB. 🙂

Especially with the headaches that come from running between 30,000 and 50,000 package executions per day 🙂

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

Phil Parkin SSC Guru Points: 246985 More actions · Answer 2

mtassin (8/15/2013)
Hey Koen,
Nice article. I hope you'll at some point discuss the headaches of managing the execution logs of projects deployed to SSISDB. 🙂
Especially with the headaches that come from running between 30,000 and 50,000 package executions per day 🙂

Someone definitely needs to write that article, I agree.

Nice work Koen. Not sure about 'automatization' though - surely 'automation' does the same job faster? 😛

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

jbowers Old Hand Points: 369 More actions · Answer 3

You state that the wizard method of project deployment "is of course not suited to deploy projects to the production server". As someone who is just upgrading from SSIS 2005 to SSIS 2012, I'm curious... WHY is that deployment model not suitable for production?

Phil Parkin SSC Guru Points: 246985 More actions · Answer 4

jbowers (8/15/2013)
You state that the wizard method of project deployment "is of course not suited to deploy projects to the production server". As someone who is just upgrading from SSIS 2005 to SSIS 2012, I'm curious... WHY is that deployment model not suitable for production?

I suspect it's because we all hope that production DBAs don't use wizards and instead have everything scripted out.

... even though some probably do 🙂

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

Phil Parkin (8/15/2013)
mtassin (8/15/2013)
Hey Koen,
Nice article. I hope you'll at some point discuss the headaches of managing the execution logs of projects deployed to SSISDB. 🙂
Especially with the headaches that come from running between 30,000 and 50,000 package executions per day 🙂
Someone definitely needs to write that article, I agree.
Nice work Koen. Not sure about 'automatization' though - surely 'automation' does the same job faster? 😛

Thanks guys.

There are already some articles/blogs on the subject of SSISDB logging (and on how it sucks). I believe there are some performance improvements in SP1 or some CU.

Regarding automatization: I looked it up while writing the article and it does seem to exist. 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

Phil Parkin (8/15/2013)
jbowers (8/15/2013)
You state that the wizard method of project deployment "is of course not suited to deploy projects to the production server". As someone who is just upgrading from SSIS 2005 to SSIS 2012, I'm curious... WHY is that deployment model not suitable for production?
I suspect it's because we all hope that production DBAs don't use wizards and instead have everything scripted out.
... even though some probably do 🙂

That's indeed one of the reasons 🙂

The other reason is that I shudder with the thought that someone is giving enough permission to deploy something straight out of a development environment into production.

You're at least missing a step of using a integration/test server.

Brrrr.... 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 246985 More actions · Answer 7

shoesus4 (8/20/2013)

Wonderful.

Share a website with you ,

( http://www.shoes2.us// )

Believe you will love it.

We accept any form of payment.

http://www.shoes2.us/Michael-Kors-Handbags-n2447/%5B/quote%5D

Reported as spam.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

Phil Parkin (8/20/2013)

shoesus4 (8/20/2013)
Wonderful.
Share a website with you ,
( http://www.shoes2.us// )
Believe you will love it.
We accept any form of payment.
http://www.shoes2.us/Michael-Kors-Handbags-n2447/%5B/quote%5D
Reported as spam.

I'm pretty sure the "wonderful" part was not spam, but a honest-meant comment on the article. 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 246985 More actions · Answer 9

Sure. And I also reckon that

Believe you will love it

refers to the SSIS Catalog maintenance task 🙂

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 10

Phil Parkin (8/20/2013)
Sure. And I also reckon that
Believe you will love it
refers to the SSIS Catalog maintenance task 🙂

Without a doubt in my mind 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP