Thats what I was thinking. Just wanted to make sure there wasn't something new out there

Anything with Brian Knight as one of the authors. Also you can pick up quite a bit on youtube

When i do the following:

In Solution Explorer, right-click the SSIS Packages node, and then click Upgrade All Packages to upgrade all the packages under this node.

I don't see any packages...

Had to add the missing pkgs to the solution and a "(1)" was appended to the end of the package name and listed it at the bottom instead of alphabetical...

I think I may need to upgrade ssis 2008 packages to SSIS 2012 before upgrading to SSIS 2014

Oh yeah! Been there done that.

Thanks, next question...Haven't seen anything online on converting SSIS 2008 packages to 2014....Is it the same way you would upgrade 2008 packages to 2012?

I just copied and pasted it into my browser and it worked. You can also google "SSIS File System Task Rename File" and get a slew of returns.

Go here for more descriptive explanation: http://www.bidn.com/blogs/KeithHyer/bidn-blog/2465/copy-and-rename-a-file-in-ssis-using-the-file-system-task

use an SSIS variable and use an expression in the variable to set the value to hold the name concatenating the date part you are wanting. Then use that in...

Use a File System task.

Was dropping the table and using select into to create it again then selecting all from the table into an excel destination. Had to update the stored proc to truncate...

Ahh, yeah there was no need for the left join and adding that actually corrected the code as well as speeded up the process. The search that was taking 20...

I'm 99% sure that the server hasn't been restarted in a couple months

Turns out I was able to speed it up by looking at the query plan and adding some indexes.