Click here to Skip to main content
15,116,813 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi Friends,

I am new to SSIS packages. I have an SSIS package Solution in my local machine.
It has an XML Source component which uses an XSD file in my local machine.
When I deploy this on my SQL Server, How can I set the path to a new location on server ?


1 solution

Better to add an configuration file in SSIS and store your XSD File path in it... This will allow you to change values after deployment.[^]
Yesudass Moses 5-Jan-15 8:07am
This package doesn't seem to be using configuration files.
Can I edit the deployed dtsx package and change the path there ?
deepakdynamite 9-Jan-15 7:26am
You won't find it ... you need to add configuration... which will be converted into XML file after deployment. Please go through link provided and atlast yout will see XML file... where you can change values

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900