That's backward from what I was remembering but it looks like it might do the trick. Let me test it and then give you praise for doing what I...

C'mon. Someone must want to figure out this process.

From what I remember we did an insert of all new records (changed and truly new). Then there was an...

Why not use _sp as a suffix? It still shows that the code is a stored procedure and lets you group things by name much more easily.

I've advocated that...

In upper management speak 'technical debt' has no value add. The code works so what's the point in spending time aka money on it?

The real trick is to get...

Can they do it? Yes. Should they do it? No.

Saying the tests were 'too stringent' says they don't understand why the tests are set up that way....

Very timely indeed. We're currently in the process of building clean databases from the .. ummm .. less than optimal solutions that were in place as well as building...

Look at the size of the string field in your flat file connection. If it's greater than 23 then SSIS will 'helpfully' tell you you're going to truncate your...

One company I was at went to project level deployment in 2012. While the use of variables for data connections and parameters and such were really helpful there are...

I'm with the tricksy question that penalizes us for best coding practice crowd. Code that throws errors should not be used as much as the old sp_ prefix shouldn't...

Conditional Split.

Send your data down different paths based on some criteria and then into multiple Excel file destinations.

Here's my thoughts on how you might do this.

Use SSIS as your bridge between servers since that's what it does.

Create stored procedures to do the data selection. Since you're...

Try using a Powershell script since you're doing a file system search.

Get-ChildItem -Path "[path]" -Recurse | Select-String -Pattern "[pattern]" | Out-File "[output file name]"

This will search recursively so start at...

Some suggestions.

If possible make a Send Mail task that will run in the package OnError event handler. Lots of notification there but maintenance depending on how you set up...

Bad managers tend to get identifed after all the critical highly-talented people leave. This has a lasting effect inside and outside the company.

The employees that are left are less...

Wow. Just wow. I wrote that over six years ago and it's still helping people.

I'm kinda choked up right now. And I'm also glad that I took...