umayal5 (11/4/2009)

---

I didn't attempt to save the trace and did not look over the trace. We were trying to capture the results when the program ran successfully (related to currency...

You are new to both Oracle and SQL Server yet someone expects you to be responsible for these types of changes? Do you have a background in RDBMS's or...

Sounds coincidental to me. Profiler doesn't lock tables. When Profiler was running, did it capture the query that was sent by the client's program?

SQL Profiler does not place locks on tables. It does use system resources but from my experience, not enough to have a noticable impact on the end-user.

Is...

Good point Lynn. Partitioning is only available in certain versions.

Is another better way to query my tables instead the view?

You think adding partition and let the archive process will...

Man, you're fast Lynn. You got 2 posts done in the amout of time took me to write out a one sentance post!

Well, if the SP is returning a dataset and you need to comine them, the only other way I can see would be to use INSERT INTO EXEC to get...

What is happening inside of RPT_TargetDatesReport? If you need the output all in one data set, I would recomend writing a version of RPT_TargetDatesReport that works off of a...

Each task in the control flow waits for the previous task to complete. If you have 2 precedence constraints leading into a task, it will wait for both to...

That makes sense. I was just wondering if there was some funky looping logic that we needed to worry about.

I would go w/ Phil's suggestion for now. ...

That may be what you're stuck with. I was going to suggest using Profiler to get you the text plan, but you'd still be stuck with pasting that plan...

So all of this is inside a data flow and the data flow is inside a for each loop?

Why the for each loop?

I assume then that the application is using their login? Have you tried logging in as that user via Management Studios and reproducing this behavior? This may make...

What do you mean that it 'dumps' the data?

I'm a bit confused on what you want to accomplish here. Are you wanting to move the objects from the user's schema into dbo or just change their default...