DSXchange

An Execute Command stage can return the count and then the 'if-then-else' would be handled by custom trigger expressions - one to email and another to run the FTP job.

My performance impact statement was generic, not specifically about this particular case.

I prefer the option that is more visible and maintainable and for me that would be your #2... unless there is a serious performance impact for that choice.

There is no official mechanism that I recall. When the site went premium, a handful of us were approached and agreed to the role of 'Premium Posters' and I don't think there are any plans to add any more.

(fyi - decided to move the post here)

Well.

Can you post the complete, unedited error message please? I'd also be curious if there's anything different about that shared object file, permissions perhaps?

There you go again.

As noted, there are several ways. You could look into passing that date stamp in as a job parameter and then leveraging the job parameter in the filename. You would set it upstream of the job, formatted however you like, and then pass it in. That way there's nothing needed 'after job'.

I would assume that is what they are doing. And I assume the goal here would be to reduce all that if-then-else activity down to something more manageable. As noted, a parallel routine could cut that down but nothing will remove the fact that you'll need to do something to each and every field you w...

I was assuming it was the 'Not Applicable' dimension row that facts can tie to when they have no corresponding element from that dimension. That way you don't have to do an outer join to get every fact row, even if they (technically) have no matching dimension record.

First question in my mind would be where did you make these changes? One should be in the engine directory and the other in your project. Forgive me, but off the top of my head I don't remember which one is where... but I believe that uvodbc should be in the project. If that doesn't fix it, I'd veri...

No, it's not possible to do anything 'conditionally' in the Before SQL area. About all that comes to mind as an alternative might be making the entire statement a parameter and you include the 'load the default row' command on the initial run and leave it empty on all subsequent runs. We just have a...

So, yes if you run Parallels or VMWare on your Mac so you have a working Windows environment there.

Just an EMT Ray, an Early Morning Typo. :wink: And I just have to add - you are getting way too anal in your old age. Yes, they are stages. And yes, those stages represent activities. The documentation likes to flip-flop around on how it refers to them: Designing a job sequence is similar to designi...

Why 8.0.1? Those early releases were notoriously buggy.

I'd suggest asking for help from your official support provider as your next course of action.

Read the documentation where (from what I recall) that is very clearly explained.