SQL Server Performance

Consolidation of SSIS packages

Discussion in 'SQL Server 2005 Integration Services' started by raagi2000, May 21, 2008.

  1. raagi2000 New Member

    Hi
    I am using SQL2K5 I have SSIS Package1 and Configfile1 SSIS Package2 and Configfile2 and so on... Currently i am running it manually one by one on SMS using integration services. I have assigned to automate the process or consolidate into a single package. I can automate it using execute package tasks without config file. there is no option in the execute package task to point to the right config file. Any pointers on this would be appreciated.
  2. kirankdba New Member

    You can configure each package with its own config file by selecting SSIS tab then Package Configuration. As you said create a master package use execute package tasks to call other packages from file system or server.
    Hope this will solve you problem as package configuration is specific to a package.
  3. dineshasanka Moderator

Share This Page