Running SSIS Packages with Python

Microsoft's SSIS (SQL Server Integration Services) is a ubiquitous ETL (Extract Transform and Load) tool. Despite its widespread use, SSIS is not loved! At best, it's tolerated for its undeniable utility, but SSIS's “utility” comes with a host of hideous warts with the ugliest being its file handling. You would think that an ETL tool … Continue reading Running SSIS Packages with Python

NumPy another Iverson Ghost

During my recent SmugMug API and Python adventures I was haunted by an Iverson ghost: NumPy An Iverson ghost is an embedding of APL like array programming features in nonAPL languages and tools. You would be surprised at how often Iverson ghosts appear. Whenever programmers are challenged with processing large numeric arrays they rediscover bits of … Continue reading NumPy another Iverson Ghost