Password for ODBC Connections

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. This is my string connection : " Driver={iSeries Access ODBC Driver};uid=FTPUSRTEST;system=ASBCTEST;dbq=SDBFILCOMP SDBFILCOMP SDBINFCOMP SDIFILP OPCFILP CLUFILCOMP;dftpkglib=QGPL;languageid=ENU;pkg=QGPL/DEFAULT(IBM),2,0,1,0,512;qrystglmt=-1;translate=1;libview=1;prefetch=0;signon=1;blockfetch=0 " I been reading and someone says that i can put the password in the string, but i need the password be encripted so and that way no one will see it.

Honestly i don´t know whats else can i do to resolve the problem.

I need a way to save the password on the conection.

Sorry for my english i´m from Argentina and i´m not a good writing.

0
edit delete
are you sure?
asked Andres Abarca Jeanne

0 answers

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions