Congratulations!

And thanks for the references.

You cannot use the variable like that directly. (e.g. placing a ? instead of a servername is not an option).

You need to use dynamic SQL. Create a string that contains...

I have enlighted the important pieces for you:

Started: 9:17:39 AM

Error: 2010-11-22 09:17:39.84

Code: 0xC0011007

...

First of all, those two options - DelayValidation and RetainSameConnection - have nothing to do with connection problems, so it's normal they don't solve your problem 🙂

How do you configure...

Try enable logging in your package.

See this tutorial of MSDN: http://msdn.microsoft.com/en-us/library/ms167061.aspx

As GilaMonster already mentioned, exact counts can't be given, but the percentages that you mentioned are roughly to be expected. Each tool has its development and maintenance chapters in the...

You shouldn't use 0, but a question mark.

A question mark tells the parser that a parameter is expected. In the parameter mapping, you specify those parameters. The names are the...

You were right, no questions like...

As it is XML based, it should be possible. You'd simply have to parse the XML and navigate to the appropriate hierarchy/node.

But I have no experience doing that and I...

Maybe it has something to do with the problems mentioned in this thread:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/289d0bbb-1d06-4856-9c66-8d3e540d7be9/

Nice question, although a link to a reference would have been nice.

(ps: quite bizare I answered the QoTD of 22th November on the 20th of November. Time travelling? :-))

bladerunner148 (11/20/2010)

---

Hi,

I changed the protection level of the package in BIDS as EncryptSensitivewithPassword. Upon saving the package, it asked me to enter a new password. When I imported this package...

It certainly is a permission issue. You encrypt the package with EncryptSensitiveWithUserKey, but then you execute the package under a different user (the domain account of SQL Server Agent to...

I don't really understand. You write some files to a table. And then you want to read from the table in a data flow task. Can't you just use an...

krriegle (11/19/2010)

---

Thank you all. I used the Transcender practice exam. It was useful because the questions differed in scope than the training kit questions but for future exams...