This code returns exactly the right number of rows and the numbers in the 'closing balance' column are right.

But there is only one calculated field 'closing balance' and when...

Many thanks for the reply. I have slightly modified the code for the actual views. But it is still not group the data togther.

;WITH

cteGeneralLedger

(GNLID,GNLCLIID,GNLCOAID,GNLFSMID,GNLBalanceBase)

AS (

SELECT...

When I try execute the SP I get an error message.

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >,...

What I am trying to do is email from SSIS one dynamically changing text file and one excel file at the same time.

In my SSIS package I have declared four...

Jason-299789 (1/10/2013)

---

Marbo (1/10/2013)

---

Hi ringovski,

I don't fully understand what your point is but isn't it simple to use a second send email task with probably a second variable or expression.

Or create...

Problem is solved 🙂 if anyone is intrested....

I found that I had to enable deployment from the package properties and build. Then use the deployment tool to deploy the...

How do I check that?

The SQL source is sorted, one side from the multicast accepts the source as sorted but the other doesn't.

It was pretty easy in the end, added last join. Thanks for trying all.

SELECT Sh.LocationID, sh.code,Sh.Description, Sh.StartTime, Sh.Duration, ...

Sweet...

doesn't matter I worked it out, add the email task after the condition export so it only emails if the previous task runs.

Thanks guys for the replies, your script works.

Just as a excercise I am trying to use a nested query and am unable to get it working. Both these return the...

Found the problem the variable had to be package wide not just data flow task in scope.

Koen Verbeeck (8/9/2011)

---

You can add a rowcount in your dataflow. (this stores the result in a variable)

Then, after the dataflow, you can use the variable value in an expression on...

I got it working by removing the null in the Select statement, the dervied editor was detecting the NULL.

ISNULL(optional_3l, '') AS [Division Code]

So the column is always empty or has...

I have changed it to make more simple and it still doesn't work, when I query the DB there is actually a null record in that column [Division Code].

ISNULL([Division Code])...