good question, right now that s4 hana erp is in a different domain.  we just bought that company.  however ssis can run over there .

i'm not sure if running over...

here is what i think "hops" would look like in this arrangement.   They wouldn't be hops in the traditional sense like ssrs -> sql engine when ssrs and the engine...

• This reply was modified 2 months, 2 weeks ago by stan.

i believe i got it with the help of AI searching for a response to "ssis for each file enumerator i want a wild card concatenated to a variable value...

• This reply was modified 3 months, 1 weeks ago by stan.

thx, not totally getting it.   all of our targets are varchar.   so even if this flavor of utf allows extended character sets in a column meant for a varchar landing,...

• This reply was modified 3 months, 1 weeks ago by stan.
• This reply was modified 3 months, 1 weeks ago by stan.

thx ken, by risk i really meant ssis usual issues with uni to non uni and vice versa challenges.  We have millions of records going thru our etl currently i...

• This reply was modified 3 months, 2 weeks ago by stan.

the downside of race conditions sound almost like the downside of dirty reads.   At least under this isolation level.

• This reply was modified 4 months ago by stan.

this article helped me a bit.

https://www.google.com/search?q=does+rcsi+introduce+significant+slow+down+in+existing+queries&rlz=1C1GCHZ_enUS1176US1176&oq=does+rcsi+introduce+significant+slow+down+in+existing+queries&gs_lcrp=EgZjaHJvbWUyBggAEEUYOdIBCjE4MzcwajBqMTWoAgiwAgHxBVyGQjH11NIA&sourceid=chrome&ie=UTF-8  .

-hopefully the fact that select statements read an older version of the record isnt contradictory to what a shop floor system should do.

-i have...

ths Ross, i will read that doc.   My understanding is that snowflake has now purchased an etl product/company.    What i'm gathering is that snowpipe isnt for large amounts of...

thx Steve, i have a meeting with one of their reps to ask, amongst other things,  why they bring etl biz partners to their seminars if snowpipe is a good...

thx ant-green, report what?   The buggy ssms 21 product or now going on close to a day that my latest  sql server central post on ssms 21 issues disappeared?

...continuing issues...

• This reply was modified 4 months, 2 weeks ago by stan.
• This reply was modified 4 months, 2 weeks ago by stan.

there have been 3 updates that i'd like to post ...

-i installed ssms 19 side by side with the buggy ssms 21 and it has no problems in the gui...

i uninstalled ssms and reinstalled with copilot preview and all is well.   thank you.

so...which if any of these is ssms?   This seems somewhat confusing.    am i installing all 4?   how about for core functionality?   in the old days i think we installed...

• This reply was modified 4 months, 2 weeks ago by stan.

smo 17.100 is the latest so i'll now try a reinstall.  hope it doesnt break vs and put me in a wild goose chase.

running oe details as admin got the same error.    i could be crazy but i think even earlier (on rt click) than attempting the same (rt click and script...

• This reply was modified 4 months, 2 weeks ago by stan.