SSIS Execute Package Task

Question

SSIS Execute Package Task

Andy Leonard

SSChampion

Points: 10144
More actions
November 18, 2010 at 8:54 pm

#243065

Comments posted to this topic are about the item SSIS Execute Package Task
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

Viewing 15 posts - 1 through 14 (of 14 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Great question. Luckily I had this right, as I have my 70-448 exam today. If I got it wrong, I would've panicked. 🙂

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 2

Good question. I tried to find the asnwer on the internet, but failed, then had to use my common sense to choose an answer.

Andy, is there any reference (other than your courses, which are both geographically and budgetary out of my reach) for this?

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 3

I always enjoy your questions, they keep me thinking. Thanks.

SanDroid SSChampion Points: 10068 More actions · Answer 4

da-zero (11/18/2010)
Great question. Luckily I had this right, as I have my 70-448 exam today. If I got it wrong, I would've panicked. 🙂

Good question. After five plus years of SSIS I had never tried doing this before today.

Good luck on your test Zero!

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

My thinking was that you should be able to provide a password and the called package would just ignore it. This is the only way it made sense to me. Then I assumed it must fail or there would not have been a reason for the question. BAH!!! Over thinking got me in trouble again. Good question.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Andy Leonard SSChampion Points: 10144 More actions · Answer 6

Da-zero: I doubt you will ever see somethign like this on an exam question. I would object to this kind of question, personally.

Hugo: I am considering every option for course deliveries. I'm writing (more like desiging than writing...) a course called Mastering SSIS. I'm thinking of people who already know how to write SSIS packages and deploy them to a Production environment. It includes every quirk (like the quirk mentioned in this question) of which I am aware, loads of SSIS design patterns, SSIS framework components, maintenance and troubleshooting techniques. Another option is mentoring: I can work with you on an hourly basis and with your data on an hourly basis. I've done this kind of work remotely in the past, with success. Contact me if I can help you sir.

Daniel and Sandroid: Thanks! I encountered the need to run encrypted and non-encrypted packages from the same dynamically-configured Execute Package Task. Like a good engineer I conducted a smoke test, and it passed! Thank goodness. I would have needed to do something else if it hadn't.

Sean: I've done the same thing a bunch of times. Great minds...

I'll have a couple more questions in coming weeks. Thanks for the encouragement and feedback!

:{> Andy

Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

UMG Developer SSChampion Points: 13482 More actions · Answer 7

Thanks for the question!

Your "Mastering SSIS" course sounds like it will be really interesting/useful.

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 8

Andy Leonard (11/19/2010)
Hugo: I am considering every option for course deliveries.
(...)
Contact me if I can help you sir.

Sir? I'm not called a sir very often!

Thanks for offering those opportunities, but I have to decline at the moment.

Frankly, I have no need to learn SSIS at the moment. My life is filled already with trying to acheive a high level of mastery in plain T-SQL code, DB design, and a base level of DBA mastery. I don't have the time to learn another aspect of the product. And since I have no need for it in my business life, I have to pass on really getting into it.

That is exactly why I am very glad with your SSIS questions here. They at least force me to put in a quarter of an hour every now and then to research some aspect, so that I gradually do get at least a basic feel for the product. If I ever come in a situation where I have to learn, I'm sure that I'll find I already have some basic understanding, and your questions contribute to that.

I'm looking forward to your next questions!

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

TomThomson SSC Guru Points: 104773 More actions · Answer 9

Nice question. I didn't know the answer so had to think about what would be likely to happen. Fortunately reached the right conclusion.

Tom

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

Andy Leonard (11/19/2010)
Da-zero: I doubt you will ever see somethign like this on an exam question. I would object to this kind of question, personally.

You were right, no questions like this one on the exam 🙂

Andy Leonard (11/19/2010)
Hugo: I am considering every option for course deliveries. I'm writing (more like desiging than writing...) a course called Mastering SSIS. I'm thinking of people who already know how to write SSIS packages and deploy them to a Production environment. It includes every quirk (like the quirk mentioned in this question) of which I am aware, loads of SSIS design patterns, SSIS framework components, maintenance and troubleshooting techniques.

This sound very very interesting. If you happen to drop by in the Belgium area sometime, let me know 🙂

Andy Leonard (11/19/2010)
I'll have a couple more questions in coming weeks.

I'm looking forward to them! (is this a correct expression? Babelfish gave me worse options)

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

sharath.chalamgari SSCertifiable Points: 5680 More actions · Answer 11

Nice Question, i got it right because recently i faced this kind of situation in one of my package.

i am looking forward to here more on "Mastering SSIS".

RichardDouglas SSCarpal Tunnel Points: 4029 More actions · Answer 12

Good question, thanks for taking the time to help educate the SQL community.

Hope this helps,
Rich

[p]
[/p]

Andy Leonard SSChampion Points: 10144 More actions · Answer 13

da-zero (11/21/2010)
I'm looking forward to them! (is this a correct expression? Babelfish gave me worse options)

Yep - that's the correct expression!

:{>

Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

Thanks for the Question Andy.

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