I have used SQL Discovery Wizard from Quest (http://www.quest.com/discovery-wizard-for-sql-server/) and it is free, not sure you can capture the results into a table though.

There are some powershell scripts...

I have used SQL Discovery Wizard from Quest (http://www.quest.com/discovery-wizard-for-sql-server/) and it is free, not sure you can capture the results into a table though.

There are some powershell scripts...

You could use COPY_ONLY in the Native backup so it doesn't set a checkpoint and risk impacting the CommVault backups.

From memory (which is normally wrong) I think that error is related to Kerberos/Delegation.

Dan

You could try SQLIO or SQLIOSIM from MS (http://www.microsoft.com/en-us/download/details.aspx?id=20163) to test the I/O throughput on the servers, there might be better tools out there though.

I also find the...

I have worked around it by creating a new script task and assigning the variables in that (copy and pasting the code form the script task that won't work) -...

Just tried renaming the variable, which caused expressions to fail (proves it was recognised somewhere by ssis) renamed it in the script and ReadWrite variables - same error!!

The variable is...

robertm (12/10/2008)

---

In that case then these are the two most likely causes of your issue:

1. You've misspelled the variable name. Might sound silly but it's worth checking and then checking...

robertm (12/10/2008)

---

Is this a script task (control flow) or component (data flow)? If in the data flow then you can only access variables in some methods, e.g. preexecute, postexecute. From...