Craig Farrell (3/13/2011)

---

Anyone around willing to take a readability review of an article (though will probably be split in two) I'm in the middle of writing? I need a...

Here's a unique way of doing the special / invisible character search. Your mileage may vary:

DECLARE @y xml;

SET @y=(SELECT MyID, MyColumn

from MyTable where MyColumn=''

FOR XML RAW, ELEMENTS XSINIL);

SELECT convert(varchar(5000),@y);

EDIT: You'll...

Now that's an interesting solution I never would have thought of.

But Parsename() only works because it's treating the IPAddress as a Server.Database.Schema.Object item (because of the periods). It wouldn't...

Ah. Stefan found the Substring version I was trying to do. I forgot about starting location in CharIndex(). No wonder I couldn't get it to work.

You're welcome, Roy. Glad we...

Here's a brute force solution:

SELECT CASE WHEN Substring(IPAddress,3,1) = '.' AND Substring(IPAddress,6,1) = '.' THEN Substring(IPAddress,1,5)

WHEN Substring(IPAddress,3,1) = '.' AND Substring(IPAddress,7,1) = '.' THEN Substring(IPAddress,1,6)

WHEN Substring(IPAddress,4,1) = '.'...

No, Lowell. Not easy at all. And it's not about price. Approvals have to go through our Corporate office. Applications are rigorously testing to make sure they are compatible with...

Much as I'd love to use one of those two options, we can't use unapproved software or components.

However, I am allowed to write up SSIS components myself... If I had...

Let me know if you need a beta-reader. Backup theory & practice is one of my favorite areas.

lijnenjoost (3/11/2011)

---

Why don't you use a Script Task to unzip or to zip your files in SSIS. That way you don't need a zip tool and you don't get unexpected...

opc.three (3/10/2011)

---

Random thoughts...

Curious, what is @ doing in your command line? This is what I get when I run your code:

Just a hunch...try surrounding your file...

hor_netuk (3/11/2011)

---

My experience. - At interview, the technical interviewer expressed dislike of acronym use. The non-technical interviewer replied, "funnily enough, I didn't know what DBA stood for until you...

It's the Attack of the Acronyms!

Two years ago, we implemented a new process that uses the acronym "RI". I've been working on that process ever since. I've gotten so ingrained...

As in Importing to Integration Services? Or BIDS?

You know, I don't do the logging bit, but I do the moving the flat files all the time.

I'll take this one. Learning the logging will be fun. @=)

I should start...