Easy one for Monday, thanks.

You'll need to parse the string yourself. Have fun with that 🙂

Maybe convert it to unicode first and then to 437?

Just for testing purposes, what if you changed the Send Mail Task to an Execute SQL Task? (and do some insert statement into a table for example)

herladygeekedness (4/25/2012)

---

uh, even odder - the correct number of rows went to staging, the wrong number of records is shown in the flow.

Please ignore post, it's a non-issue (aside from...

Jack Corbett (4/25/2012)

---

Another option is to place that task in its own package so you can execute it as a child task in the existing package or as...

Why exactly can't you use the dataflow?

If you run the sp in the OLE DB source, doesn't it return the rows needed?

Any add-ins running in Visual Studio?

Where did you put the Send Mail Task? In an event handler?

It seems the person making the requirements has no idea what a cube is.

A cube is made to aggregate data (aka measures) and look at those measures from various viewpoints...

Next time, also post the error message. It would be quite hard to debug without it.

Have you rebooted your machine?

Maybe try a repair using the SQL Server set-up?

Or do a clean re-install?

Hugo Kornelis (4/27/2012)

---

Interesting question, thanks Koen!

I had it wrong because, like Mohammed, I had to google - and I found this reference that appears to contradict the reference Koen used:

In...

I'll tell you a little secret:

most of us posters can't either....

Nice question. I apperently missed something about the explanation.

Ah well... 🙂