how big is the table?

if only a few thousand rows then a script with insert statements would likely work fine as mentioned before.

but for anything with volumes BCP or powershell...

Another option if you don't want to be moving data between your local and the prod server, creating temp tables, CTE's etc... would be to use SSIS and just...

• This reply was modified 3 years, 1 months ago by frederico_fonseca.

replacing the CR + LF on a text field IS losing data - maybe not important on your case, but it is still data.

In one of the migrations on my...

what worked? creating a valid CSV file or removing potentially valid data from your output? and if removing valid data...

not as easy as that. the environment within a SQL job step is a number related to the number of the environment on that particular server.

trying to recreate the same...

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 3 years, 1 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 3 years, 1 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...