Look up SUBSTRING and see if that's what you're thinking.

The package is not going to be changed. So adding tasks isn't my easy out.

From my original code snip you can see I just want to execute the package if...

Since this can be handled relatively easily through job scheduling we'd prefer not to edit the package to handle the logic. Plus we're trying to rip out each and...

dspohn23 (11/6/2009)

---

Since I wasn't able to find a free SSIS documenter with unlimited use, I decided to build my own. It's not perfect yet, there still needs some additional testing...

Sweet! Exactly what I was looking to do!

Now I can make a stored proc that we can use in any and all jobs that require notifications.

Thanks!!

I believe there's a very large difference between preventing the use of SELECT * FROM.. in a production environment and using it in a development environment.

For development it's almost a...

After I started doing the research into this I found out that even once the files get imported there's processing variations. :rolleyes:

We have no control over the format of...

I'm looking to do something similar without using a third party solution.

We've got files coming in that are all in different formats but need to go to the same destination....

OK - I'm going to put my (extremely simple) suggestion here. Obviously it's looking for the basics of an email address - @ and .XXX. Yes, addresses using...

This might be such a low level that it's assumed but when I've had file access issues it's because the account used to access the file is the account that...

Caveat - we had very few people modifying stored procedures so YMMV.

We used the old-fashioned "follow procedure" method of doing version control on stored procedures. It wasn't perfect but...

I've functioned as an anti-mentor for a few folks and the best piece of advice I've been able to give is this:

"Put in exactly as much emotional investment as you...

One other gotcha on NULL values and the conditional split is that the NULL conditions need to be resolved before anything else. So if you've got multiple conditions anything...

Not...

Not exactly elegant but you could put a File System Task in the control flow and have it set a file attribute. On fail (no file) direct the flow...