How can I change XSD Path in deployed SSIS Package

Question

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 ?

Thanks

Posted 5-Jan-15 0:42am

Yesudass Moses

Add a Solution

1 solution

Add a Solution

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

deepakdynamite · Answer 1 · 2015-01-05T02:03:00

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/[^]

Posted 5-Jan-15 2:03am

deepakdynamite

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

How can I change XSD Path in deployed SSIS Package

1 solution

Solution 1

Add your solution here

Preview 0

How can I change XSD Path in deployed SSIS Package

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us