he...

FYI made changes in the import wizard and the data imported just fine. I do suggest that when you post a problem, whether here or another site, that...

if you had to create the spn's I would advise restarting the service.

load into a staging table

do joins to main target table - if existing record update, if new record insert . (do updates first)

even if you are using SSIS to do...

are you using SSMS on your own PC to do this or rdping to the server and using the SSMS on each individual server?

if on the server then the issue...

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...