First of all you cannot implement (without EXTREME PAIN) sha256 in a stored procedure..

With that said however, you can get an extended stored procedure that that can handle it, I...

That all sounds kind of interesting.. If the error was limited to SSIS I ight have bought mismapped, but you get it at the end of every OLEDB destination..

I...

I don't believe the each database name as a DNS entry can work, there really is no connection between the DNS name and the database itself. If you have...

Is the SQL 2008 installed as a default instance listening on port 1433.

On the SQL 2008 box is the SQL Browser running?

On the boxes that work are you using aliases...

It is pretty clear:

[OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005...

What is the exact message thrown, if necessary screen print and attach..

Where are the databases that the package uses, local, or remote. Ones locally, it could be trying to...

I don't see any reason why not, the code treats this as basically a set operation, the update I used had an OR instead of an AND, but that is...

I've known many bosses who want what they want.. But ROI and costs often cause them to rethink it. Payroll in the EU or even Albania cannot be...

I agree it sounds like blocking but I think he meant sp_who not sp_whoo..

CEWII

I think the other settings are fine but the Max Memory one is troubling. SQL has a history and a tendency to use all available memory is many cases,...

I can see a couple solutions, but I still need a bit more information, is the sproc operating on all data in the table or just a particular record, your...

That really isn't that wide, you get about 32-33 records/page, about 1.333-1.375M pages, so about 10GB, that will take a while to re-index.

Will the new index help with...

First I would not use the NOLOCK hint, second of all I would probably use the Read committed isolation level, the upside is that is the SQL default..

I rarely change...

What is the scope of the variable you are trying to adjust. If it is not at the package level this won't work.

I'd try this:

'/SET "\Package.Variables[User::Data_ID].Value;17'

Or for a different...

The user that edited the package last is the user that must execute the package to get the sensitive information decrypted. You either have to execute it as that...