That is why I stated either the /quiet or /passive arguments - which depend on the version you are installing.  For the 2010 version you have to use the /quiet...

This is not the appropriate way to create files from SQL Server.  You can use BCP to output the data to a file - or SSIS - or export an...

Just my opinion - but I would not utilize an AOAG with Standard Edition for anything other than DR.  For an HA solution I would stick with a standard FCI...

What is the purpose of outputting the results of the job to text?

How are you running the SSIS package *manually*?  What are the exact steps you take?

When you run the package from SSDT/VS - do you get this error?

How are the connections...

It all depends on how you execute the package - if you try to run the package within SSDT in debug mode it runs as a 32-bit application.  In fact,...

Is the code that is executed in these packages trying to use a linked server?  If so - then the only way to fix that is to setup and validate...

Which one of the rows for BAG-CV do you want?  The calculation you have here is going to produce a different result for each row - so how can you...

Just tried it (accessdatabaseengine_X64.exe /passive for the 2016 version) and it seemed to work - at least, it didn't genertate any errors. I don't know how to check whether...

Well yes, but that's not really the point. The package which the import wizard generates has no bitness and is executed by DTExec.exe, which has both 32- and 64-bit...

<li style="list-style-type: none;">

<li...

It sounds like a problem on the destination - I would suspect something is blocking the insert into that 2005 instance once you exceed a certain number of rows.

Are you...

Not sure why you are messing with the JSON files - they provide the files in text or Excel format.  From this page: https://www.fda.gov/drugs/drug-approvals-and-databases/national-drug-code-directory

Unless your report is limited to a...

Sorry - since I don't have those tables or any sample data I wasn't able to validate the code.  I missed the closing parenthesis on the sum...

SELECT...

I would probably look at downloading the text file and uploading the data into table(s) in a reference database.  I could then join to the table(s) to get the values...