How to set OLE DB Source data in SSIS
Sometimes I have to learn things repeatedly before it sticks. I re-learned this tip from Tim Costello at last night's Oklahoma City SQL User Group presentation. We will get his presentation up soon. First, a big thank you to Tim Costello for coming to Oklahoma City to speak at our user group. Check out his site for more tips. This tip was just one tidbit from his presentation "Pro Tips: Tuning the data flow in SSIS". Watch for him at a SQL Saturday near you. Why you need to set IsSorted property on the OLE DB Source When preparing…