I have a rather simple SSIS package that exports data through an ODBC connection from an IBM iSeries database and copies that data to a SQL Server 2005 database. When I was designing the application, I was able to connect to the iSeries database and
store the user ID and password with my BIDS project and copy the data with out any problems. Great!
When I finished designing and testing the project, I loaded it to the production server. The final test was to schedule the process so that it would run each night. I didn't realize it at the time but the password that I had stored with the project
in BIDS was removed from the package and various MS documentation stated that I should create a configuration file and load the password from there. So, I made the necessary changes to the project, adding a configuration file. The config file is
in the Miscellaneous folder within the BIDS project, however, it isn't automatically copied to the bin directory when I build the project. I have to manually save it to the server, and then after importing the project I have to manually link to the necessary
This fixed the problem with the server, however, now I can not get BIDS to save my password with the connection string from within the designer. This is a huge problem. I am exporting from 21 different da
View Complete Post