ai approach going down the winscp path

generic AI script recommendation...this is part of it...

2 challenges so far.    I'll post my progress here.  I'm using vs2022.

if i use the more generic approach shown by AI in my first image (posted separately) , i...

setting the protection level to "dont save" didnt at least allow me to "test the connection".   nor did following that up with the "passive" check box.   i'm moving on to...

thx lisa and steve.   simply reducing the number of rabbit holes like you guys have done is invaluable.

before i go the code route, i may try toggling one of those...

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

thx steve, yes i always go to advanced with things like this.  in this case, in the final oledb destination, i change the data type in advanced and ssis ignores...

• This reply was modified 3 weeks, 6 days ago by stan.