Iggy,

Per the...

You are welcome.

CEWII

Sorry, only have a moment, but I think in the script component, a string data type has the SPLIT function which I think will do what you want.

CEWII

Marc,

If I understand the question, you have the no match add it to the database and you want to get it back into the normal pipeline? If that is...

I'm a little fuzzy why the tables are changing so much..

Usually it shouldn't require a rebuild, you might have to visit each component but it shouldn't make you rebuild....

Jeff,

I've reviewed that code and as I read it, you have to take advantage of a hack that allows you to use xp_regwrite as a non-privileged user coupled with an...

Jeff Moden (6/10/2011)

---

You've got me there. ...

You can't prevent the validation, you can delay it. There is a flag on nearly every container that is DelayValidation (or something real close to that), I'm willing to...

It made things simple for me and I didn't have to try and figure out where the error occured, I know. I'm thinking the performance hit was fairly small....

I'm not sure exactly what your question was, but I try to keep things fairly simple.. So let me lay out how I typically handle things.

Don't mind the error...

I think I might go a little further than Lowell, I view it as, at minimum, a questionable practice. You are taking a lot on faith, you know, like...

You are very welcome Jeff, I look forward to an example.

CEWII

Jeff Moden (6/10/2011)

---

Elliott Whitlow (6/10/2011)

---

Jeff,

I agree that you can use xp_cmdshell in a *more* secure way but I just don't want to risk it. Maybe thats just me.. ...

Good information Cozy, I wasn't aware of that one..

CEWII

Fair enough..

CEWII