Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SSIS Execute Package Task Expand / Collapse
Author
Message
Posted Thursday, November 18, 2010 8:54 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:44 PM
Points: 389, Visits: 1,041
Comments posted to this topic are about the item SSIS Execute Package Task

Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1023274
Posted Thursday, November 18, 2010 11:47 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 13,538, Visits: 10,412
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1023317
Posted Friday, November 19, 2010 4:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:11 PM
Points: 5,965, Visits: 8,217
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
Post #1023404
Posted Friday, November 19, 2010 7:07 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, August 16, 2014 9:15 AM
Points: 2,818, Visits: 2,557
I always enjoy your questions, they keep me thinking. Thanks.
Post #1023498
Posted Friday, November 19, 2010 7:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
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!
Post #1023522
Posted Friday, November 19, 2010 7:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:03 PM
Points: 13,241, Visits: 12,083
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 Moden's 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)
Post #1023524
Posted Friday, November 19, 2010 8:24 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:44 PM
Points: 389, Visits: 1,041
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
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1023560
Posted Friday, November 19, 2010 10:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Thanks for the question!

Your "Mastering SSIS" course sounds like it will be really interesting/useful.
Post #1023677
Posted Friday, November 19, 2010 11:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:11 PM
Points: 5,965, Visits: 8,217
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
Post #1023748
Posted Sunday, November 21, 2010 3:30 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 8,679, Visits: 9,205
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
Post #1024087
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse