Twin/Koen, It was a typo. It's infact dstx. I was just cleaning the official info from the logs. Rest...

Microsoft (R) SQL Server Execute Package Utility

Version 10.0.5500.0 for 64-bit

Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 3:15:22 AM

Error: 2013-11-29 03:15:22.02

Code: 0xC0011006

Source: {12GE82DD-A13X-52A8-5542-2G7F5C4ADB59}...

I tried this as well but it's not working. The path i'm giving for this package is like:

C:/.../dtexec.exe /f "\\ServerA\SSIS\Packages\MyPackage.dstx"

Can there be any issue with the path ? Permissions for...

It's EncryptSensitiveWithUserKey.

Pretty straight forward question. 🙂

I've seen in my case where an index on one huge table was taking too much time. I did it with SORT_IN_TEMPDB = ON and it completed faster (though still...

Very straightforward. Thanks for making life easy Steve. 🙂

Good question. Feeling nice to cover up after more than a week's leaves. 🙂

sestell1 (11/19/2013)

---

Hmm, I wonder if the confusion comes from the 'replacement' section:

I assume that indicates the...

Good QOTD for Monday. 🙂

Nice QOTD Raul. 🙂

I didn't give it a though and straightforwardly clicked the answer but just after clicking (in split of seconds before showing teh result), i thought i didn't...

Good question Steve. It gave me little hard time. 🙂

Koen Verbeeck (11/13/2013)

---

First of all, this question is way too easy. Enterprise has all the features, so you don't even have to think.

Secondly, developer is the same as enterprise feature-wise,...

Frankly speaking I was not aware of the answer and simply had to track it down using google. The first site i saw gave me the answer. But good informative...

Yes, I'm looking to pickup the excel file dynamically based on the name (having date added as string to the name). Let me try and get back. 🙂