Query Result in BIDS are slower than SQL

Jan 22, 2015 at 9:44 AM
Hi,

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.

regards,
Vipin jha
Coordinator
Jan 27, 2015 at 12:03 AM
Is this the same problem you asked about here?
https://bidshelper.codeplex.com/discussions/578210

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