I read through this - don't have any additional thoughts about the migration assistant issue.  With that said - I am very curious why you are running through the assistant...

I know I've said this before in this thread. I can run the script from Powershell without any issues. The script isn't local to the PC. It's on a...

I see your point Jeff, and that makes sense.  You can't just assume that the missing column is the last one or that new columns will always end up...

If the string date is in the format YYYY-MM-DD then in an expression just replace the '-' with '' and convert to integer.  Or - as Phil stated, create a...

If a file had 24 fields yesterday - and now has 25 fields - I want the process to fail.  I don't want to assume the new field added was...

Standard Edition supports basic availability groups - which are very limited.  You can only have one secondary - it cannot be read only - and it only allows a single...

My scripting abilities are woefully subpar. It's why I tend to use existing tasks to do what I can rather than throwing script tasks in my packages. However, when...

Did a quick search on: ssis sharepoint download file

There seems to be a lot of ways to accomplish downloading a file using SSIS - which would be the first step...

I wonder if using ExecutionPolicy Unrestricted in the command line is overriding the previous Bypass setting on the command line?  You don't actually need to specify both - one or...

In the outer apply for 'jm2' you can remove the group by - it isn't needed here.  In the outer apply for 'jo1' you need to add an order by...

As part of testing I removed the JobHead and JobAsmbl tables from both SubQuery statements but the execution jumped from 00:00:01 to return 28,800 records to 00:00:06.

The JobOper and...

How will you be querying this view - once it is completed?  I am thinking this might be better as a stored procedure - with parameters to filter to the...

I would say the biggest improvement was switching to OUTER APPLY.  The CTE wasn't necessary - but it wasn't really causing any issues.

As for your question about views, this becomes...

It only reformats it if you...

If I am reading this correctly - you should be able to do this without needing a function.  You can replace this code:

    ...