SSIS Configuration File | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSIS Configuration File

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.[|)]
Hi Gurus,
I think everyone has overlooked my Question?
Please reply.
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.
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.
]]>