I have created an ssis package which pulls the data from IBM DB2 to a SQL table. To connect to DB2 i was using a project parameter DB2_ConnectionString as below
Data Source=bludb;User ID=xxxx;password=xxxxxx;Provider=IBMOLEDB.DB2COPY1;Persist Security Info=True;Location=xxxxxxxx:50000;Extended Properties=;
I am unable to encrypt this password in the connection string. Tried changing the package protection level to Encrypt with password and changed the sensitive option to True in the package. Created an XML config with property as connection string.
Is there a way i can separate out the password (encrypted) from the connection string and use that as environment variable in the package ?