Wow, I wonder if the OP is still around, this thread seemed to start in 2006...

CEWII

I have to admit that I have never even tried, I have used lookup very often. As a workaround you might add a RIGHT statement to your initial query...

You could probably build a script task to handle this but I think you have a much bigger problem. The fact that all the excel files are of a...

Good article Andy, I look forward to reading the rest of the series..

CEWII

A quick look at the packageexecution.jpg appears to contradict your assertion.. while they are listed in reverse order the start and end times seem to indicate that it is...

You are very welcome.

CEWII

It sounds like a validation problem. There is a setting called DelayValidation at the package level (and others) that I am 99% sure is set to false. If you...

Without trying to be flippant, it...

pwalter83 (3/23/2011)

Aren't triggers used by DBAs? 😉

If Service Broker is too far out of your comfort zone, I would go with the solution of Phil Parkin or the one of...

pwalter83 (3/24/2011)

The destination server has security implications and as such only the SSIS port is allowed on the server. This is the reason I think that a trigger would need...

Paul,

I'm sorry to be this blunt but the gist of this thread is that this is an a bad practice. If you would like to discuss alternatives that can certainly...

I have worked in shops both requiring SOX and not, nothing with HIPAA yet.. However, even where SOX compliance isn't required that doesn't mean that applying change control and...

What I was really trying to get to was the real requirement. Here on the forums we very often get specific questions about how to do this or that....

I think you are generally right, some SMTP servers won't allow it.. But you can try..

CEWII

I think a from address is required. I often use a mailing list as a from or a specific name and a mailing list as a reply to. ...