Oops, never mind. I see that DTSrun is definitely DTS (I was getting it confused with DTExec).

Is this really DTS or is it actually SSIS?

This is basically the price you pay for the flexibility that EAV brings.

And developers love EAV because its seems like a dream during the Design and initial Development phases, especially...

Ajdba (8/31/2012)

---

Thanks Lowell.

But this @Years(2001,2002,2005,2008) values are passed by the users thru stored proc and years can be different every time; in this case, do you think I can...

Though, given that your tracer tokens seemed to be getting through, it seems like it was the monitor that was affected.

I don't think that's a problem, but I cannot remember for sure. I think that those are the log file pages that were backed-up (and now restored) by the...

Mark Eckeard (8/31/2012)

---

The rollback after the error trapping is the issue. It's rolling back your error record. Move it before that insert.

RBarryYoung's code works although there's an extra...

How did this work for you?

The line terminator can be any of CHAR(13), or CHAR(10) or CHAR(13)+CHAR(10).

Gail:

Didn't the OP say that this was Sql Server 2005? Can you still do something like that on 2005? (Yikes!!!)

Yes, there's actually a number of open-sourced examples out there on CodePlex and a few other places.

Sadly, the best one by far (SSMS Tools Pack[/url]) is not, which...

You know, instead of "REPAIR_ALLOW_DATA_LOSS", they should have named that option "RISK_SHOOTING_YOURSELF_IN_THE_FOOT", or maybe "DO_NOT_USE_UNLESS_YOU_REALLY_KNOW_WTF_YOU_ARE_DOING".

:crazy:

I looked into this too at one time. As I recall, SSMS 2005, 2008 and 2008R2, use essentially the same shell/environment from the standpoint of a VS add-in. ...

Well, the Isolation_Level could affect this.

Also, have you checked to make sure that they are all the same version of SQL server?

Heh. Now this is do-able! 😀