i thought i posted what a rabbit hole this looks like but i dont see the post here.   Anyway, AI says the ado connector is downloaded as part of the...

the ado.net path looks promising.   My only concern is keeping it updated with whatever changes occur in sap.

The cdata alternative which is buried further in your links has my interest...

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 1 week, 6 days 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 1 month 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 1 month ago by stan.
• This reply was modified 1 month 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 1 month, 1 week 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 1 month, 3 weeks 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 2 months, 1 week ago by stan.
• This reply was modified 2 months, 1 week 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 2 months, 2 weeks ago by stan.