JanTimmermans (9/21/2012)

---

Hi, did you solve it, because I have the same issue.

I also use a cursor, but that has to stay in the procedure.

When running it from SSMS, it flies,...

Grouping...

I feel like I have entered a parallel universe.:alien:

venus.pvr (9/19/2012)

---

I have a parent package(Pkg1) which executes Pkg2 thrice in parallel. And Pkg2 executes Pkg3 thrice in parallel. These packages have variables(with same names between childs and parent) passed...

Eugene Elutin (9/19/2012)

---

Yes it is possible, but what it will give you?

SELECT Col1, Count_Rec

FROM (SELECT Col1, Col2, Count(*) AS Count_Rec

...

One thing which I have noticed with MERGE is that it does not natively provide separate Updated/Inserted/Deleted counts.

You need to code an OUTPUT clause and use $Action to get these....

No. If...

Is that because words are too...

keka4747 (9/19/2012)

---

Hello Gurus,

Im new to SSIS . Need your help to resolve a performance issue.

I have a dimension table with 120 columns in which 80 columns change frequently and...

I second all of Sean's comments.

In addition, I note that you are referencing a column in your example which does not even exist in the table (ri_user_name).

I suggest that you...

Excellent - no problem.

OK, I see that one.

I think your problem may be that your flow can go down either one path or the other, but not both.

The Execute ... task is waiting...

I'm sorry, that link does not work for me ("Sorry, that page was not found." is the message I receive)

Cool. I'm a bit short of time so can't go into detail.

But what you need to use is a package variable. Set its value in the script depending on the...

I'm afraid you might be in the wrong place. This is a SQL Server forum, not Oracle.