VERIFIED SOLUTION i
X

Is it possible to change paths within Sagent plans via SQL

UPDATED: September 20, 2017


Scenario:
The user has several plans which reads & writes to the files and the file path has changed where it were located. Is there any way path can be changed without modifying the plans through SQL query on the respository?

File path changes through SQL queries might corrupt the repository. The user can fetch plan folder name, plan name, step name, current file path from repository, but changing through SQL scripts is not a recommended practice.

Follow the steps:
  1. Login into Design Studio.
  2. open plan in staging area.
  3. change the file path supplied in the respective transforms.
  4. save the plan.




 

Environment Details

Product Feature: Repository

 

Downloads

  • No Downloads