SQLServerCentral.com / Discuss Content Posted by Andy Leonard / Article Discussions / Article Discussions by Author / SSIS Execute Package Task / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 13:42:44 GMT20RE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxThanks for the Question Andy.Wed, 24 Nov 2010 11:01:32 GMTSQLRNNRRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspx[quote][b]da-zero (11/21/2010)[/b]I'm looking forward to them! (is this a correct expression? Babelfish gave me worse options)[/quote]Yep - that's the correct expression!:{&gt;Mon, 22 Nov 2010 07:07:29 GMTAndy LeonardRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxGood question, thanks for taking the time to help educate the SQL community.Mon, 22 Nov 2010 05:30:55 GMTRichardDouglasRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxNice 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".Mon, 22 Nov 2010 00:12:35 GMTsharath.chalamgariRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspx[quote][b]Andy Leonard (11/19/2010)[/b][hr]Da-zero: I doubt you will ever see somethign like this on an exam question. I would object to this kind of question, personally.[/quote]You were right, no questions like this one on the exam :-)[quote][b]Andy Leonard (11/19/2010)[/b][hr]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.[/quote]This sound very very interesting. If you happen to drop by in the Belgium area sometime, let me know :-)[quote][b]Andy Leonard (11/19/2010)[/b][hr]I'll have a couple more questions in coming weeks.[/quote]I'm looking forward to them! (is this a correct expression? Babelfish gave me worse options)Sun, 21 Nov 2010 23:57:23 GMTKoen VerbeeckRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxNice question. I didn't know the answer so had to think about what would be likely to happen. Fortunately reached the right conclusion.Sun, 21 Nov 2010 15:30:51 GMTTomThomsonRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspx[quote][b]Andy Leonard (11/19/2010)[/b][hr]Hugo: I am considering every option for course deliveries.(...)Contact me if I can help you sir.[/quote]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!Fri, 19 Nov 2010 11:39:14 GMTHugo KornelisRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxThanks for the question!Your "Mastering SSIS" course sounds like it will be really interesting/useful.Fri, 19 Nov 2010 10:08:05 GMTUMG DeveloperRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxDa-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!:{&gt; AndyFri, 19 Nov 2010 08:24:47 GMTAndy LeonardRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxMy 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.Fri, 19 Nov 2010 07:29:40 GMTSean LangeRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspx[quote][b]da-zero (11/18/2010)[/b][hr]Great question. Luckily I had this right, as I have my 70-448 exam today. If I got it wrong, I would've panicked. :-)[/quote]Good question. After five plus years of SSIS I had never tried doing this before today.Good luck on your test Zero!Fri, 19 Nov 2010 07:27:12 GMTSanDroidRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxI always enjoy your questions, they keep me thinking. Thanks.Fri, 19 Nov 2010 07:07:21 GMTDaniel BowlinRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxGood 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?Fri, 19 Nov 2010 04:24:50 GMTHugo KornelisRE: SSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxGreat question. Luckily I had this right, as I have my 70-448 exam today. If I got it wrong, I would've panicked. :-)Thu, 18 Nov 2010 23:47:52 GMTKoen VerbeeckSSIS Execute Package Taskhttp://www.sqlservercentral.com/Forums/Topic1023274-208-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Integration+Services+(SSIS)/71701/">SSIS Execute Package Task</A>[/B]Thu, 18 Nov 2010 20:54:11 GMTAndy Leonard