Search code examples
sql-server-2008ssisinstallation-package

Deploy SSIS Package with SQL Server Authentication

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.

Solution

  • One solution I have used in the past for easy deployments has been BIDS Helper.

    BIDS Helper

    May not be exactly what you need, but once your package is deployed, you can setup a SQL Agent Job to execute the package on a regular schedule.