SQL Server Performance

SSIS Configuration File

Discussion in 'SQL Server 2005 Integration Services' started by ranjitjain, Jun 16, 2006.

  1. ranjitjain New Member

    Hi All,
    I created DTS package with a user variable and saved the configuration in XML file.
    I deployed it on different server and while installation changed the value of that variable.
    But when i execute the package it still takes that old value and throws error.
    But when i execute by adding the configuration file path it runs successfully.
    Is it that i need to add that config file path everytime i run.
    How to install that DTS on different server so that it will read directly from that config file and not it's inbuilt values.[|)]
  2. ranjitjain New Member

    Hi Gurus,
    I think everyone has overlooked my Question?
    Please reply.
  3. satya Moderator

    http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2342.aspx

    HTH

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  4. ranjitjain New Member

    Hi satya,
    I can't view that bolg as it is blocked in my company.
    Can you please copy and paste the content of page.

Share This Page