Hi everyone I´m working with Visual studio data tools to create a DTSX that will work in SSIS. when I create the ODBC Connection I need to write a USER and PASSWORD for this connection but the password is not persistent.
I am executing SSIS packages that override the Connection string by submitting new connection parms from batch execution of the package using dtexec.
Hi, trying to create a SSIS flow to extract data from source (AS400) to destination (SQL) db. The flow is relatively easy: connect, extract and put it in destination folder.