The future SSIS (v6) will likely embrace Python as a transformation language. Start using Execute Process Task to call Python scripts or Script Task to run Python via IronPython or .NET interoperability.