should have gone with my gut instinct. But, I see some potential for the function in a couple of places, so will go look it up.

Thanks!

I did find this: https://docs.microsoft.com/en-us/learn/paths/implement-sql-data-warehouse/

Its one of the training modules, and it falls under the Data Engineer role. But I had to work backwards, first to find the...

I got no kick with the questions and the editorials. In fact, the questions and editorials help me focus on things that might improve my queries, so keep it up....

I got it wrong, but 42, which is the answer to life, the universe, and everything was not an option for this question. At any rate I learned another valuable...

The car I miss most is the 62 Chevy Biscayne I drove back and forth to college. straight 6 3 speed, it could take all manner of abuse and keep...

I do have days when I wish Microsoft would offer SqlAgent as a standalone product. I've tried a number of job management systems, and I continually come back to SQLAgent...

technically, I would think that you would work a half day and then knock off, so if you normally start at 8 am your time, you would knock off at...

Are your VM's in different data centers by any chance? I have a slightly similar situation where the test ETL server is in one data center and the test database...

I have no experience at all with that command, so I can't help you there, but I think I would find it easier to pull them into Visual Studio, convert...

Is the previous 5 years worth of data available for you to retrieve the 2 new columns for your historical data?

If its not, then you can only modify your SSIS...

I've recently purchased a nice Thinkpad, and have set up Hyper-V to manage virtual environments. At the moment I have one VM running Linux and a second one running a...

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...