Nested Schemas Target File off the Job Server

dataservices job design
1

I’ve run into a rather weird issue and was wondering if anybody has had any luck getting around it.

I’m building an XML file from existing tables, and can’t use the default bin folder in Data Services, but rather on a remote UNC path due to Storage constraints (ex: \example_server\d$\Folder_Name). If I keep my File Location empty, it creates the file with no problems, however, this doesn’t meet the requirements.

Things I’ve tried:

  • Using a global variable for the File Location (escaping the slashes)
  • Using a Substitution Parameter for the File Location, but I get an invalid file path.
  • Creating a File Location in Formats > File Locations (in Local Object Library). I get rather weird register errors.
  • Using the entire UNC path + Variable in the File.

I’ve attached an image: http://imgur.com/a/L2TcL. Hopefully this makes sense!

vernong1992 (BOB member since 2017-03-01)

2

If you print the variable for the UNC, does it appear correctly?

If you log in to the DS Server are you able to CD to the UNC using the user that the DS Services run under?

What version of DS?

What is the host operating system for DS Server?

  • E

eepjr24 :us: (BOB member since 2005-09-16)