Development SQL Server Job Agent fails SSIS package with error: Option “/CALLERINFO” is not valid

I was editing some pre-existing SQL Server Agent jobs the other day, adding some interconnectivity and changing steps around as I’ve done hundreds of times before.  These job steps are used to execute SSIS packages (SQL Server Integration Services) on the server and have been running for months (years?) without fail.  However, after I made my changes they started failing on the steps I had edited, throwing the bizarre error:

Option "/CALLERINFO" is not valid.  The command line parameters are invalid.

read more
Development Reverse the order of words in a string in SQL Server

I recently found myself with a situation in SQL Server where I had a string consisting of a series of values (constructed using the CLR function for concatenating values that I wrote about last week) that I needed to reverse.  Unfortunately, it’s not as simple as using SQL Server’s built-in REVERSE function.  That actually reverses each individual character in a string, rather than switching the order of words.

read more
How to open your NAT settings for Xbox LIVE on O2 Wireless Box II
Gaming How to open your NAT settings for Xbox LIVE on O2 Wireless Box II

I’ve had my fair share of issues with my broadband connection since signing up with O2 (provided by Be There) 3 years ago. Fortunately, it’s improved a great deal over that time and is now extremely stable. The biggest problem I had was playing online via Xbox LIVE, especially getting my Network Address Translation (NAT) settings right on the supplied O2 Wireless Box II (essentially a rebranded Thomson-Alcatel TG585v7).

read more
Workaround for the Battlefield 3 “no weapon” glitch
Gaming Workaround for the Battlefield 3 “no weapon” glitch

In my free time lately I’ve been getting into the superb online multi-player in EA and DICE’s Call of Duty baiter, Battlefield 3 on Xbox 360.  For anyone who’s not tried the series, it’s a large scale multi-player military shooter with wide open maps and a variety of land, sea and air vehicles with which to play.  While it’s enormous fun, especially if your fellow players work as a team it’s unfortunately riddled with game-breaking bugs.  Some players seem worse affected than others and the issues seem to be spread across all three of the game’s platforms; Playstation 3, Xbox 360 and PC.

read more
Web & technology Klout online influence scores gaining extra sway

If you’re a reasonably social media-savvy person, you’ll no doubt have heard of (and perhaps used) Klout, an innovative online service for measuring online influence via social media.  Klout’s unique selling point is their own calculation of influence, the Klout Score.  While it’s not exactly new to the social sphere, having been on the go in some shape or form since 2008, Klout have recently been engaging in a substantial push to increase the scope of their offering by adding many more social networks and features.

read more

About

picnicerror.net is a personal blog where I post various ideas, thoughts and discoveries through both my day to day work in marketing technology and general hobbies and interests.

Know More

Social