SQL Server Performance Forum – Threads Archive
SSIS Configuration FileHi 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.[|)]
I think everyone has overlooked my Question?
http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2342.aspx HTH Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.
I can’t view that bolg as it is blocked in my company.
Can you please copy and paste the content of page.