Viewing 15 posts - 6,316 through 6,330 (of 9,715 total)
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) = '.'...
March 11, 2011 at 11:16 am
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...
March 11, 2011 at 10:13 am
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...
March 11, 2011 at 9:55 am
Let me know if you need a beta-reader. Backup theory & practice is one of my favorite areas.
March 11, 2011 at 9:51 am
lijnenjoost (3/11/2011)
March 11, 2011 at 5:12 am
opc.three (3/10/2011)
Curious, what is @ doing in your command line? This is what I get when I run your code:
"D:\Program Files\Winzip\wzzip.exe" -m \\MyServer\MyShare_dev\Folder1\Processed\Group\Item\Details_201103101058.zip @\\MyServer\MyShare_dev\Folder1\Processed\Group\Item\Details.lst
Just a hunch...try surrounding your file...
March 11, 2011 at 5:00 am
hor_netuk (3/11/2011)
March 11, 2011 at 4:27 am
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...
March 10, 2011 at 10:15 am
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. @=)
March 10, 2011 at 9:40 am
GilaMonster (3/10/2011)
I'm talking about the case where someone starts a new thread solely to say "Hey everyone, I wrote an awesome blog post on XYZ, go read it!!!!!"
I should start...
March 10, 2011 at 6:32 am
Gianluca Sartori (3/10/2011)
GilaMonster (3/10/2011)
I know Steve has removed a couple of threads that people started solely to promote their blogsOK, so... report this post as well!
Except you're a regular...
March 10, 2011 at 6:25 am
Report it. It's still spam, even if it is BI related.
March 10, 2011 at 5:48 am
smac (3/10/2011)
Koen Verbeeck (3/10/2011)
Brandie Tarvin (3/10/2011)
March 10, 2011 at 5:31 am
From what I read on the initial email, it sounded to me like the file is local to the server. Koen, however, keeps mentioning the words "remote path". Is the...
March 10, 2011 at 5:05 am
Viewing 15 posts - 6,316 through 6,330 (of 9,715 total)