i opened a separate post at https://www.sqlservercentral.com/forums/topic/re-install-of-vs2022-and-core-tools-leaves-me-short-of-ssis-output-and-input-com to focus on the missing components.

going to close that one.   apparently they only show when in a dft.

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

so i uninstalled anything looking like it was vs related and installed vs 2022 because we had to anyway.   I'm poking around inside vs 2022 to add ssdt items but...

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

thx phil, i sat with our ops guy and learned vpn'ing wont happen from my phone.  just outlook using my work account, teams using my work account  and one note...

i think we'll start like this...

Start Date ____  X      and Time: ____             End Date ____   X        and Time:______

X represents the...

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

i may try that Phil.  thx.   just circled back to this.

i think we have a partial answer.   I dont know for how long but apparently when in the office i was on wifi.   One of our ops guys who looked...

• This reply was modified 1 year, 3 months ago by stan. Reason: clarity

thx Brian.  appreciated and i didnt feel like you were hijacking.

the curious thing is that its affecting only myself and possibly one other person in her SAP work.

and we work...

• This reply was modified 1 year, 3 months ago by stan. Reason: clarity
• This reply was modified 1 year, 3 months ago by stan. Reason: clarity

thx Phil.  I sent the issue to our ops/network guys.

I provided them with examples of 3 products i use that i believe use the "transport layer" to do their thing...

• This reply was modified 1 year, 3 months ago by stan. Reason: readability

thx frederico.   so that link basically says its only a fast load option.    bad memory on my part.

thx Brian.   Unfortunately you are seeing a mention about the speed issue out of context.   I was just trying to find COMMIT size here like i believe we used to...

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

thx ed are you talking about these?   so every source to dest occurrence in the dft shares in this total or has its own pair of these same limits.   i...

i ran the pkg from csv to sql on the sql server itself in 25 SECONDS.     Not sure what to conclude from this but i'm tempted to open a...

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

i ran the pkg sql to sql.   it ran in less than 5 seconds.   because i have a derived column component between the sql frokm and to adapters, i believe...

-update...i ran the pkg with a csv file as an ssis  flat file connector.  and it took just as long, approx 30 minutes.   all i can conclude from this is...

i should have mentioned that the multiple runs today were over vpn from my home.   whereas yesterday all the failing was inside the firewall at work, ie on prem internally. ...