In those cases I might consider creating a persistent temp table in...

Definitive answer!

1. SQL 2008 and SQL 2008R2 Standard Edition WILL install on a cluster that contains more than 2 nodes.

2. SQL 2008 and SQL 2008R2 Standard Edition setup will operate...

Absolutely. You need to look at the for-each loop component. As well as you will use an expression to change the login information. I hope (pray?) that...

I would surmise that you are running the package under a different user than is was created with. The default protection mode for packages causes saved credentials to be...

Simple Answer, you can't realy, MAYBE if they were on your email system and some DRM was in place.

If you have an email it can be easily disected...

Perry,

That is what I thought would happen. I have installed many enterprise edition SQL boxes and I figured the process was the same. I just didn't know if...

Oh well.. I released a SQL CLR file function library on codeplex in march 2011. It is at:

http://nclsqlclrfile.codeplex.com/%5B/url%5D

Let me know what you think, what is wrong with it, and...

Really.. Hm... I didn't, but it could be the code you were using, good to know..

CEWII

Sean,

I have considered the multiple 2-node clusters but for cost reasons it may be too much. Thanks for the thought.

CEWII

Use an EXEC SQL task to fill the count variable and you should be able to leave the init express alone.

CEWII

It is related to something called CONCAT_NULL_YIELDS_NULL, which basically means if you add up values and ANY of them are NULL then the result is NULL.

Here is the query two...

Assuming the the bracketed names are fields:

SELECT tblApplicant.ApplicantID, [LastName] + ', ' + [Suffix] + ', ' + [FirstName] + ' ' + [MiddleName] + '.' AS [Full Name]

FROM ...

For most jobs I usually set the owner to sa, meaning run it in the context of the system and sa never leaves the company. As a precaution, I...

Sean,

The install will not let you install two instances in the same cluster group, as far as I know it is not a supported configuration. You *might* be able...

I think this whole approach is overkill, you can do it with an EXEC SQL task using input and output variable mapping. About the only code needed is the...