SQL Server agent needs to run as a Domain user most likely - and with access to the internet (which in may companies is blocked on the servers)

to connect to integration services you need a SSMS associated with that particular version of Integration services - this is a known issue with SSMS

although there are some...

if you are trying to retrieve onto SSMS it will always take a long time for that volume. SSMS is not made for that purpose.

how long does it...

DataVault 2.0 does indeed require hashes to be fully compliant.

It is an interesting reading, with some parts not for the faint of heart, but it does work well...

on top of what Jeff said - I would strongly consider upgrading to SQL 2016 SP1 Standard (or 2017 Standard).
with this upgrade you would get
- table and index...

they are different in that the order by is different - one gets the biggest tables (order by totalspacekb desc) the other the ones with most unused space (unusedspacekb desc)

there were 2 queries - this is the output of which one?
and do give the 50 rows of each please.

and are you on a Enterprise or Standard...

Depending on other factors and volume of data following may also be a option.

Mainly dependent on whether you can identify updates/deletes/inserts on the target tables easily.

Add...

you changed what you didn't have to change.

you stated that you had already picked " as the text delimiter - that needs to be set
once set and...

no. what I said, and gave the example, is that any double quote that is part of the source text needs to be escaped with another quote

December 8, 2018 at 4:19 am

#2015818

yes - but as your file format is incorrect it needs fixing.

if the quotes are escaped (with another quote) then the file will load correctly, and the final...

this has been discussed over and over again both in this forum and elsewhere

as that is not a valid CSV file SSIS will not process it correctly.
Ask...

what is the size in pages of the indexes where fragmentation doesn't change?

and taking in consideration that most of the injections is done using hex representations of the data it is quite easy to inject if not using parameters.
https://www.c-sharpcorner.com/article/sql-injection-with-hex-code-and-its-prevention-mechanism/

and...