Programming

Creating a Setup Package for a Custom SSIS Data Flow Component

To make an installation package for a custom SSIS component the .dll(s) that make up the component must be installed into two places:

  1. For design time it needs to be installed in the SQL Server's pipeline components folder C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents
  2. For runtime it needs to be installed in the GAC

All your setup package has to do is install the .dll(s) into both of these places and you are ready to rock n' roll. This micro-howto doesn't cover aspects of the GAC (like signing code) or developing an SSIS component, for those topics I would recommend www.sqlis.com. Read on for notes on creating an installation package.

Read more...


Front page on dzone.com

It is a relatively new site so this doesn't really get filed under earth shattering or momentous, but it is kinda cool. Now I'll just sit tight and let the clicks roll in... all 30 or so of them ;-) Either way, it got 6 votes while I still only have 3 diggs, proving that digg sucks twice as much as dzone. Props to Basil for the submission.



Parsing Incomplete or Malformed URLs with Regular Expressions

This is part 1 of a two part article on url handling. Part 2 will talk about normalizing and joining urls (a link will be posted when it is up).

Read more...


Connecting A Submenu In Interface Builder

The easiest way to dynamically change menus at runtime is to link the menu in the nib to a variable in your class. This is relatively easy todo if you are connecting a non-submenu item:

  • Create an IBOutlet variable:
    IBOutlet NSMenu *clientMenu;
  • Drag the header file for the controlling class onto the nib
  • Instantiate it in instances and make the connection (make connections by holding ctrl down and dragging from one object to another).

But if you want to connect to a submenu it is harder because there is not graphical representation that you can connect it to. The solution here is to use the outline mode.

Read more...


Querying the motor controller on a handyboard

For my master's thesis I need a handyboard to control both a small robotic experiment and a computer that records data. There are many small glitches that I have run into and I will be posting them here so other users of the handyboard can use what I have learned.

Read more...