ssis - Avoiding the Sort Components
When using a Merge or Merge Join component in a data flow, your incoming data is required to be sorted. While it may be easy to drop a Sort component into your data flow, it may make more sense to perform the sort in your source query (if you are using a source such as an OLE DB Source component). If you decide to use an ORDER BY in your source and want to tell the ssis Data Flow that your data is sorted, follow the below steps: First, ensure that your data is being sorted with the ORDE
Blog Content
No comments:
Post a Comment