it is highly likely that its one (or both) of 2 things

1 - server does not have required SPN's and is not authorized to delegate your credentials. (google for kerberos...

how are you exporting the data?

and where/how are you opening those files?

line returns on a valid csv file are not a problem it the software reading that file correctly handles...

Thanks Steve

Same - its only when I wish to look at an old message that I go there - today decided to go in to see if I had any message...

from my previous post "what is the performance issue you are getting (is it locks? dead locks? plain slowness?)"

Thanks Phil

link works indeed - and at least messages are there.

This is the same...

have you tried adding a debug to it

$items = Invoke-Sqlcmd -ServerInstance $server -Database $database -Query $query -ErrorAction Stop

$items |out-file "c:\sql.log"

and also try

$items = Invoke-Sqlcmd -ServerInstance $server -Database $database -Query $query...

wish we could identify these types even before they are allowed to post - would save a bit of hassle for many of us here

https://www.sqlservercentral.com/forums/topic/import-csv-data-into-existing-tables

Good - but do remember that in order to use a tool you need to learn how to use it - if you are like this with a utility like...

if you are using a SSIS package and have correctly defined the input file then it will work well with the sample you posted - but if not defined correctly...

look at the rsconfig utility https://docs.microsoft.com/en-us/sql/reporting-services/tools/rsconfig-utility-ssrs?view=sql-server-ver15

regarding your SQL Service accounts - you should be using MSA/GMSA where possible (e.g. as the user that the services run under) so you don't...

and what is the error you getting?

if your VMs are with VMWARE Esx then yes it does apply - and for it to work the following must be enabled

• Server Bios - enable max power
• VM...

or instead of using a file defined within SSIS you create and write to the file using a c# script component as a data transformation within your dataflow.

there you can...