SSIS Execute Package Task

  • Comments posted to this topic are about the item SSIS Execute Package Task

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • 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

  • 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/

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

  • 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!

  • 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/

  • 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

  • Thanks for the question!

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

  • 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/

  • 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

  • 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

  • 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".

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

    Hope this helps,
    Rich

    [p]
    [/p]

  • 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

  • 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

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

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