• Not a new lesson, but  as I was working through a couple of the early chapters I remembered how much I hate portions of SSIS. Paths have to be escaped (C:\\blah\\etc), equal is ==, and in some places you address variables by ordinal position! End of rant

  • Yeah but isn't this only if you are using the old OLE DB style?   I believe the new .NET connector classes did away with this and facilitated direct reference by columnID.  I have to double check to be sure...  Brian Knight if you are reading this, can you chime in?