In truth, while I am impressed and somewhat flattered when an MVP pauses to answer one of my questions, I am just as grateful when anyone in the community answers...

I don't have an answer for you, but...

You might take a look at https://stackoverflow.com/questions/45197675/upgrading-of-ssis-packages-from-2008-to-2014

It sounds very close to what you are trying to accomplish.

There is also this article (

I too use have been known to use whatever tool can give me the quick and dirty solution to a data update, load, etc. excel, vbscript, powershell, what have you....

I've always been a bit of a coward when it comes to using the execute package task, and have usually run with a third party task from PragmaticWorks. However, I...

Quite often I just guess, and almost equally as often I guess wrong. But, I enjoy the exercise, plus, eventually I learn the correct answer. I'm very pleased to just...

This filled 2 gaps in my knowledge store, the first being a chance to see an example of the MERGE statement, which is a statement I still know little about, and...

I really have to start reading the whole problem before I answer. Thanks for keeping me humble.

Luther

Fun is solving the problem. Its even more fun if an approach is found that is new, and sustainable, with emphasis on sustainable. If I can't re-use it and improve...

The description "version number" vs "an optional integer that is used to group procedures of the same name" has a bit of a semantic disconnect that took me several minutes to reconcile...

I would love to work with someone like that, and I would like to be more like that person as well. I see that type of person as an asset...

this I have to investigate more thoroughly. I have a number of subqueries in a long running query where I am trying to retrieve the first, the last or the...

Since you are traversing all the folders within \\srvfil01\Claims Autoload, why not just set your file mask as *.xlsx and then check the returned value for "\Pending\"  before processing? It...

I like your idea of a session on starting a blog. I find myself wanting to start a blog, partly because I think here and there I have found a...

If you haven't already, you might try  and use Task Manager to see what processes are running. It would let you know, maybe, if your job is leaving unclosed IE...