I am working with SSIS 2008. My package has two connections (both are SQL Server Authentication). One is source connection and other is destination. I want to deploy this package in SQL Server and have a SQL job run this package. I need a installer for this as well so that the package can be installed on any machine. I am not sure how to expose the connection strings and what would be the best way to do this.
Thanks.