it keeps surprising me that people still build stuff that is supposed to run on a server, were Excel/Office is neither licensed neither supported, and expect everything to work fine.

or...

any of the SQL Clients allows you to setup a command execution timeout - that is for the full execution of either a single query or the whole of a...

as per manuals you can upgrade to either - 2022 has significant functionality which would make it the desired target for me.

don't you you can find it elsewhere if it does not show on those dm views.

another thing you will not catch with those is tables used within dynamic sql. this...

for anything being kicked off by the users against the server the user will require access to the server and to the database - access can be restricted to exactly...

So all the SSIS package does it call a SP and generate the file? or does any type of transformation on the data it gets from the SP?

if no transformation...

likely not - SSIS catalog does not...

spam - exact copy of https://www.reddit.com/r/AZURE/comments/sb09bg/azure_pricing_sql_server_seems_pretty_high/ from Jan 2022

without the full code (insert + table ddl) its not possible to state the exact issue - but I would guess the order of the columns being inserted do not...

it is not breaking it - you...

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

select * does NOT CARE about CRLF - other than the thread...

but why do that update? if the data is there it likely has a good reason for it and should not be changed on a whim. (specially not if it...

HI,

fields terminated by "|" (the delimiter you used above), enclosed by '"' escaped by '"'

I have used the same test. But wherever there is a split it load as...

if that is the case then doing what I stated is what...

reason why you have your records split like that is because the data on those columns contain a CR or a LF or both - in order to be able...