I have a job in Data Services that has multiple linked data flows.
In the first data flow I have a reader, some transforms, and finnally a writer to a SQL server table.
In the second data flow I have a reader that reads from the SQL server table created as the output in the first data flow, then processes the data through some transforms.
In need to create an index on the SQL server table before the reader starts to pull records in the second data flow, but I do not see how or where this can be done.
Can anyone shead some light on this process?
Thanks!