complex query as source

I have a query to be used as so开发者_如何学Pythonurce. but this is a huge query containing lot of temp tables created and finally joining which brings select data. So I used Script Task for this query which works perfectly. Is there any other way instead of Script task ?

If you use CTEs instead of temp tables you can directly use it as a source query in the OLE DB Source.

Alternatively, you could keep your current logic in a script task but then insert the data from the final select into a temporary (physical) table. The data flow task could then do a simple select directly on that temp table.