Click here to Skip to main content
14,493,058 members
Rate this:
Please Sign up or sign in to vote.
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 ?

Thanks
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

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.

http://www.sqlshack.com/using-xml-file-configure-ssis-package/[^]
   
Comments
Yesudass Moses 5-Jan-15 8:07am
   
Hi
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100