This project has moved and is read-only. For the latest updates, please go here.

Query Result in BIDS are slower than SQL

Jan 22, 2015 at 10:44 AM

I am using Execute SQL Task to create a Global temporary tables.Then I am using Sequence container,in that i have used Data flow Task, in which I had used that Temporary table in OLEDB Source.

this is doing I am to improve the performance of the OLEDB Source, initially when I ran the same query on query analyzer it took 1 minute to complete, and the same query when i am running in oledb source it is taking more than 1 hour.

but using temporary table also I am not gettting good speed in oledb source

please suggest me best way.

Vipin jha
Jan 27, 2015 at 1:03 AM
Is this the same problem you asked about here?

Did you see my reply there?
Marked as answer by furmangg on 1/26/2015 at 5:03 PM