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

  • What you are suggesting is that I change manually all the option for the location of the child packages from FileSystem to

    SQL Server before creating the deployment utility script at build time?

    Isn't there a way to have it done at runtime, maybe using a setting in a variable?