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])...

thanks for the code tip.

Unfortunately isnull() forces you to declare a replacement of the same data type of the column.

Invoice_Id(int, not null)

Code: ISNULL(invoice_id, 0) returns a zero

Code: ISNULL(invoice_ID,)...

I am adding the code to package flow I have designed that will be added to a SQL job so it can run automatically everyday. I tried doing it in...

I have finally got it after a couple of weeks, here's the code if anyone is interested;

[Code="SQL"]

WITH cte ( Invoice_id, IssueDate,optional_1,scandate,supplier,optional_2,invoicenumber,rejected,completed,notified,comments,transferred,

...