SSL error - encryption needs to be setup correctly or disabled on the client connection string

trust server certificate below may need to be ticked if this was a SSMS connection.

for...

assuming the recipient of the file is able to correctly process a CSV file you need to ensure that the SSIS flat file destination is set to Quote the fields...

• This reply was modified 2 years, 5 months ago by frederico_fonseca.

I would say that you have a trigger on that table that is removing seconds from the column.

and I also assume you are clearing that table in order to do...

• This reply was modified 2 years, 5 months ago by frederico_fonseca.

can you try

select top 1 quote_date, convert(varchar(26), time_stamp, 121)

from dbo.OptionsEOD

order by 1

can you show both the select statement and the output - only for the one that is failing, nothing else.

your query does not tell us which table has the wrong data.

but assuming it is DBO.OptionsEOD try the following change on your dynamic SQL

EXEC('BULK INSERT #TEMP_TABLE
 ...

Hey Bruin I have to ask are you trying not to get help?  I mean several individuals posted items that your initial post was lacking and you have made...

have a read at this  https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/register-a-service-principal-name-for-kerberos-connections?view=sql-server-ver16

with it you are likely able to determine it yourself.

one thing you will need to determine is if you have a double hop situation -...

some of those variables need to be explicitly converted to varchar -  example below for @@SPID

INSERT INTO Logs.dbo.LogonInfo (Spid, UserName, LogonDate, ClientNetAddress, HostName) 
VALUES (convert(varchar(200), @@SPID), SUSER_NAME(),...

and have you done as I advised on your original thread (https://www.sqlservercentral.com/forums/topic/tracking-of-accounts-data-and-stored-procedures) and debugged your code to see what you are doing wrong?

if so what step within your multiple SP's...

YOU (not us) need to debug your code - this means going step by step through it and seeing if each step has the data you are expecting.

not going to...

• This reply was modified 2 years, 5 months ago by frederico_fonseca.

you would need to use a different tool for it (DBCC SHOWCONTIG ) - but how many do you have with compat 80? and can't you change them to compat...

dup post - see reply on https://www.sqlservercentral.com/forums/topic/code-correction-4#post-4175569

your issue is because you have databases on that 2008R2 instance that are compatibility level 80 (sql 2000)  where dm_db_index_physical_stats didn't exist.

if you wish to confirm change your code as...

have you even bothered reading the link that ratbak provided? your reply clearly indicates you didn't.