Wow.. fast reply! Thanks.

It appears that data-driven subscriptions are only available for the Enterprise version. I am running 2000 Standard.

Is it possible to execute a report subscription...

Thanks for the replies.

I guess I shouldn't be surprised (although I was) that MS released another version this quickly.

Regardless if I purchase r2 I can always downgrade if...

Jetro,

Thanks as well for replying. Yes most of our apps are .NET. I plan on having NLB Webservers for our websites/webservices apps. I'll look into your suggestion. Thanks again.

Mark,

Thanks for the reply. Yes I'll have two firewalls between each DB server as they will reside on separate networks that are geographically dispersed. I can do NAT as well.

tomailvenky,

I had a few questions...

1. Why do you have 54 branches? Is that to handle the 54 different file names?

2. Do all 54 files get imported, transformed and handled...

GSquared,

You said that it took your servers off-line most of the day. Was that both servers ("failed to" and "fail back")?

The CA Rep that edited his post hit on some very valid points... however I'm not an SQL expert nor have I ever setup Active/Passover solutions with SQL so I'm...

GSquared,

Wow thanks for the reply. It's funny b/c the webcast really emphasised on how horrible MS Exchange was at failback and how XOSoft is a good solution in place of...

Yeah the output from xp_CmdShell is good for an overall picture of what happened but trying to obtain any specific results like Records imported etc. is a pain.

Package logging eh? Cool....

Like I said I'm currently dumping the record set from xp_CmdShell into a table so I can output and store the results but hopefully the...

Elliott W,

Thanks for the reply. I wasn't referring to the execution of xp_CMDShell. What I'm looking for is if one of the steps failed within the package resulting in the...

I am able to execute the DTS Package but it won't work if I supply a value to the GlobalVariable in the DTSRun command. However If I hardcode that...

Thanks for the replies.

I'm not using RaisError so it's all about sysmessages and placeholders for me. I've searched around and one article suggested logging those errors and reading...

hmmmm... is there a way to replace those placeholders to obtain the table name or the constraint that was violated?

bitbucket,

Thanks for the reply. I saw something about the sysmessages but I thought those were universal error messages and not the custom error messages that I was seeing. I'll give...