SQL Server Performance

SSIS with Package Configuration File

Discussion in 'SQL Server 2005 Integration Services' started by danny123, Jul 18, 2008.

  1. danny123 New Member

    Hi there,
    I just created my first SSIS package as described in other thread. I used package configuration file for the connection string,
    Now i have deployed the package on staging as sql server package. Do i need to upload the package configuration file also on the server?
    If yes then what should be the location of the file?
  2. MohammedU New Member

    You can deploy the SSIS package in different ways and if you use .manifest to deploy it will create the configuration file.
    If you just copied the .dtx file or copied ssis package to msdb then you need to copy the config file too...you can keep your config where ever you want but it is better to keep all SSIS package files and config files at one place...
    When you are running the package as a job or in SSMS you can use different config files as needed. You can use multiple config files for single SSIS package.
  3. dineshasanka Moderator

  4. danny123 New Member

    Thanks guys this answers my questions.

Share This Page