April 17, 2012 at 8:23 pm
Comments posted to this topic are about the item SSIS 2012 - Parameter Precedence
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 8:25 pm
April 17, 2012 at 9:52 pm
We need more of these types, Koen.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 17, 2012 at 11:10 pm
SQLRNNR (4/17/2012)
We need more of these types, Koen.
There is another one scheduled for the end of the month.
I'll try to think of more SSIS 2012 questions 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 18, 2012 at 2:23 am
Another great question thanks.
Contrary to what I said yesterday, on reflection these 2012 questions are quite interesting and I'm learning through them.
Just a shame my company, being a bank, is slow to upgrade and I won't see SQL2012 used in anger probably at least until 2017! :crazy:
ps. Our 2008R2 upgrade (from 2000) is only now being kicked off! Yeesh! :rolleyes:
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
April 18, 2012 at 2:46 am
Nice question. Thanks.
April 18, 2012 at 6:44 am
Wonderful question. I always like seeing some SSIS questions thrown into the mix. :w00t: Keep 'em coming!
April 18, 2012 at 7:07 am
DugyC (4/18/2012)
Just a shame my company, being a bank, is slow to upgrade and I won't see SQL2012 used in anger probably at least until 2017! :crazy:ps. Our 2008R2 upgrade (from 2000) is only now being kicked off! Yeesh! :rolleyes:
Same here, although I have enough say in my bank to ensure we'll be using SQL Server 2012 before 2017 -- even if the users don't know it!
April 18, 2012 at 8:44 am
Parameters for SSIS is one of my main reasons that I'm pushing my company to move to 2012 asap.
Good question, thanks!
April 18, 2012 at 8:46 am
April 18, 2012 at 9:17 am
A rare one about SSIS -- thanks, Koen!
April 18, 2012 at 10:16 am
More SSIS questions please! Thanks Koen.
April 18, 2012 at 10:23 am
thanks Koen - kudos for SSIS & SS2012!
April 18, 2012 at 1:18 pm
Nice interesting question. Keep the 2012 stuff coming.
I answered it (correctly) on the basis of common sense (that works quite a lot for SQL server, perhaps more with each new release; pity they couldn't do that with certaiin other products) rather than knowing the answer.
But I didn't previously know that parameters for SSIS packages had been introduced in the latest version so the question taught me that before I even started to think about the answer.
Working out which of the 5 options were irrelevant (it had to be either none or the just environment variable, since the option involving the "required" status of the parameter was clearly contrary to common sense - in fact in my view contrary to sanity, and it seemed common sense to specify a default at design time and to allow a server default to be set too while not having a run-time option would be strange, to say the least) was a bit harder than working out which was the right answer, but not needed to get the answer right unless MS had done something very strange. I guessed that none of the options (other than the one requiring insanity) was irrelevant and discovered when I followed up the link in the explanation that I had guessed that wrong, there are only three ways of determininging a parameter not four, so I learnt something from the explanation and reference too. So for me it was a very good question.
Tom
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply