Home Forums Data Warehousing Integration Services running SSIS packages in msdb with SQL Agent on SQL Server 2008 R2 RE: running SSIS packages in msdb with SQL Agent on SQL Server 2008 R2

  • Hi,

    You can use a configuration file to make the changes.

    In the "SSIS" drop down select the "Package Configurations..." and you can configure which values you would like to store as configuration, and these can be stored in an XML file or a SQL Table.

    This article should help:

    http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/66500/[/url]

    Kind regards,

    Graham