i'll post the conn string info (from ssas to the engine) images separately as my reply just disappeared.   this conn string has never been a problem before.   i'll poke around...

this is all good to know.  What are the risks we've avoided in the last 2 yrs of not using encryption on these dw oriented servers?  ssrs , ssms, pbi,...

i think i get it.

1. on my pc where i have vs2022 with ssis extension installed, importing an ssis project from our 2019 sql server is always going to break...

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

this sounds familiar.    I'll probably go one of 2 ways...either install the deprecated provider on my local or switch all of this over carefully to the recommended MS provider...

for sanity purposes mostly, i imported today into vs2022 an ssis project from a sql 2019 server's catalog.   Same behavior on both perm connectors and param driven connectors.   A complaint...

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

LAST ERROR

EARLIER ERRORS

i took this a step further today.   I imported a project with about 7 pkgs from our prod 2019 sql server catalog into vs 2022 locally.  I used my regular...

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

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 7 months 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 7 months, 3 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 7 months, 3 weeks ago by stan.
• This reply was modified 7 months, 3 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 8 months ago by stan.