First, don't cross-post..

Lets all discuss this at the other one..

http://www.sqlservercentral.com/Forums/Topic1046696-391-1.aspx

CEWII

I'm sorry to be a little punchy about this, but did you bother to google this before you posted the question?

I mean I googled:

"7816B7A3-CD60-4539-BD38-C35AFC61F200" 80040154

And the first result was:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/817c6cfc-b8b2-4a6e-af59-82b2c8ebfd9a/%5B/url%5D

This result...

While I agree it is written in the log, I see no reason to read the log if I can query it directly and know it will match the logged...

Views are usually(always?) slower, and I would question if the view does any additional logic. A view is a layer on top of the table and by-and-large only ADDS...

As far as control you can't get much more than rolling it yourself.. Performance should be the same, all the maint plans do is execute SQL commands like BACKUP...

I agree with da-zero, use the explicit path to the DTExec in C:\Program Files (x86), don't rely on the...

You can connect to the database instance(s) (by virtual name) and using the SERVERPROPERTY( ) function you can use the ComputerNamePhysicalNetBIOS property. It should tell you node name that...

Paul,

Why don't you explain the process to us, it will help give better more complete guidance. I also agree with John that the EXEC SQL task is probably not...

Indianrock (1/11/2011)

---

Great checklist there Elliot. We do have change control. And annual SAS70 audits. It appears that many of the laws aren't actively enforced until you have...

How are you running the package? If it is through Agent then you need to execute the package with the 32-bit DTExec command. Unfortunately I don't have my...

Completely agree, know what changed and who changed it are very important.

How often have you asked what changed? And everybody looks at you like you are a mutant.. ...

My first thought is something is trying to hack your sql machine, you should figure out where it is coming from. The IP address of the machine(s) should be...

In general I don't like to do it if I have a choice.. Also, I am opposed to using a column containing personally identifiable information (PII) as a key...

Pre disclaimer: I am not a lawyer and I haven't stayed at a Holiday Inn Express recently..

The law that comes to mind immediately is SOX. From the IT side...

While you can do what Grant explains, I would ask why you wish to do this?

CEWII