try values instead of value

FacilityID - Decimal (12, 0) - takes 9 bytes - better to use a bigint - 8 bytes so I would look at this particular column to see...

thats all pretty and so on. but what tests did you do so far - and what was the performance difference between loading the data onto that table

...

look at this http://bilearninghub.blogspot.com/2018/05/format-date-in-ssis-mm-dd-yyyy-or.html

RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , getdate() ), 2) +"-"+RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)+"-"+(DT_STR,4,1252)DATEPART( "yyyy" , getdate() )

as you are doing a bit of calculation...

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

thats all pretty and so on. but what tests did you do so far - and what was the performance difference between loading the data onto that table

• table with...

you are the one that needs to figure that out for your own environment. test test test.

Hi folks

I can't find anywhere else to ask this, so here it is. SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean that the...

please don't post same issue twice.

original thread here https://www.sqlservercentral.com/forums/topic/msg-537-level-16-state-3-procedure-recover_truncated_data_proc-line-113-inva

Ratbak already gave you a indication of what you should do - what did you find so far after following those instructions?

that is where some disagree.

on my 1500 production db's 220 have RCSI enabled - and most new db's are being created with it enabled unless the team requesting it ask...

with that server I would change maxdop to 8 (and try out other combinations - 4 6 12)

and CTFP change to 50 - never below 25 unless fully tested and...

then, and as I said on the options, hardcode the path to the SQL Server BCP and do it that way.

easy and fast - just not portable to other servers...

Sorry but this solution is not professional in all terms. Components exist within a server for some reason, and the solution is not always to remove them in order...

basic solutions that any professional should be able to figure out after the issue has been found.

• remove whatever sybase components you have on the server
• change path order
• hardcode...

ohhh.. it does look like I was right after all.

• This reply was modified 4 years, 6 months ago by frederico_fonseca.

what error?

in SQL Server BCP the command works fine and outputs the version of BCP - on other versions of BCP (such as yours) it may error but without its...

• This reply was modified 4 years, 6 months ago by frederico_fonseca.