You do make some good valid points, but if the real requirement is to make it all dynamic, then there is a chance that the data flow is not an...

Unfortunately...

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)

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