August 15, 2013 at 12:03 am
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
August 15, 2013 at 6:56 am
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 🙂
August 15, 2013 at 7:55 am
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 15, 2013 at 8:53 am
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?
August 15, 2013 at 9:21 am
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 15, 2013 at 12:57 pm
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
August 15, 2013 at 12:58 pm
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
August 20, 2013 at 9:22 am
shoesus4 (8/20/2013)
Share a website with you ,
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 20, 2013 at 12:15 pm
Phil Parkin (8/20/2013)
shoesus4 (8/20/2013)
Wonderful.Share a website with you ,
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
August 20, 2013 at 1:00 pm
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 20, 2013 at 1:02 pm
Phil Parkin (8/20/2013)
Sure. And I also reckon thatBelieve 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
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply