SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Execute Package Task


SSIS Execute Package Task

Author
Message
Andy Leonard
Andy Leonard
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2315 Visits: 1101
Comments posted to this topic are about the item SSIS Execute Package Task

Andy Leonard
Data Philosopher, Enterprise Data & Analytics
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: General Forum Members
Points: 61811 Visits: 13297
Great question. Luckily I had this right, as I have my 70-448 exam today. If I got it wrong, I would've panicked. :-)


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Hugo Kornelis
Hugo Kornelis
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18683 Visits: 12426
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Daniel Bowlin
Daniel Bowlin
SSCertifiable
SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)

Group: General Forum Members
Points: 7918 Visits: 2629
I always enjoy your questions, they keep me thinking. Thanks.
SanDroid
SanDroid
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2404 Visits: 1046
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
Sean Lange
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: General Forum Members
Points: 61977 Visits: 17954
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.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Andy Leonard
Andy Leonard
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2315 Visits: 1101
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
Data Philosopher, Enterprise Data & Analytics
UMG Developer
UMG Developer
SSCarpal Tunnel
SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)

Group: General Forum Members
Points: 4006 Visits: 2204
Thanks for the question!

Your "Mastering SSIS" course sounds like it will be really interesting/useful.
Hugo Kornelis
Hugo Kornelis
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18683 Visits: 12426
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25825 Visits: 12494
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

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search