It looks like the problem you are having is related to the fields being quoted.  You need to specify in the BULK INSERT statement that the file is a CSV...

In order for a database to be joined - it must have the latest transactions that have been backed up applied to the destination.  To shorten the number of transaction...

This kind of issue is one reason I avoid using linked servers for ETL type processes.

If you can use Integration Services (SSIS) that would be a much easier implementation than...

Apologies, i got mixed up, i remembered that if a table is referenced by a FK it cant be truncated, but thats not the case here, so yes, truncate...

When you run through the wizard - the endpoint will be configured with your personal account.  This could cause an issue at some point when your credentials change.

To avoid this...

There could be many reasons - if the commands being executed access any data outside this database the command will fail.  Can you confirm that the view(s) you are using...

If the user only has 'Browser' role - they cannot upload any reports.  If the user has 'My Reports' enabled - they can upload reports to their folder.

SSMS already has an option to right-click and SELECT TOP 1000 (which is configurable).  As stated earlier - TOP does not utilize a sort unless there is an ORDER BY...

SQL...

Not so sure it is as bad as you stated, here is what it shows on my system.  With that said - I have started moving away from using sys.all_columns...

If you have a calendar table - or a date dimension table:

Declare @startDate date = '2017-05-07'
      , @endDate date = getdate();

 Select...

How complex is SP1 - could it be converted to an inline-table valued function?  Since all this does is generates the data to be used by SP2 - it might...

Most of these methods don't correctly handle situations where the final value is null (leaving a trailing comma).  It's simpler to handle this using leading commas rather than trailing...

Our CISO has requested more information about how SSIS is utilized to extract the data so I need to put the what port SSIS uses to extract data, what...

I have seen similar issues when a large data load is processing - or someone is running a process to create/rebuild indexes.  These processes can take out a lock that...

What are you running that requires SQL Server to be installed on x86...