Ever wonder why when you click on the green line in SSIS the Data Flow Path Editor doesn't actually let you edit anything? I did. Then I realized I needed to make the changes I wanted in the source task by right-clicking it and selecting Show Advanced Editor.