Desktop productivity for business analysts and programmers

Copy Files task won't run in process flow

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Copy Files task won't run in process flow

[ Edited ]

Hi

 

My organisation is in the process of migrating onto SAS 9.4 and hence Enterprise Guide. A lot of the scripts that I used regularly involve importing data from excel spreadsheets, which previously wasn't an issue as SAS sat locally on the machine. Whereas now using Enterprise Guide, everything executes on a server outside of our existing network.

 

I am aware of the Copy Files task which allows files to be copied to the SAS server before running a proc import for example, and this works fine, unless the task is run as part of a process flow...

 

If I run just the Copy Files task on its own everything works fine, but when run as part of the process flow it just gets skipped over, meaning the program which follows errors straight away.

 

This is the log which shows for the Copy Files task when run as part of a process flow:

Uploading files from machine "<removed>" to SAS session on "<removed">.

Using these settings:
	Source file specification: &local_path\Reference\*
	Destination path: &server_path/
	Overwrite existing files: Yes
	Resolve macro references in file paths: Yes
	Convert line endings for text files: No

NOTE: Resolving macro expressions in file paths.  SAS log:

 

 

What can I do to solve this?

 

Thanks for your help!


Accepted Solutions
Solution
‎09-22-2017 06:01 AM
Super Contributor
Posts: 460

Re: Copy Files task won't run in process flow

Posted in reply to dedwards96

I think you might have to raise this one with SAS Tech Support - there's just not enough information to go on from the log.

View solution in original post


All Replies
Super Contributor
Posts: 460

Re: Copy Files task won't run in process flow

Posted in reply to dedwards96

I don't think that task ever writes much to the log because unlike other tasks it doesn't generate SAS statements - it uses "behind-the-scenes" APIs to effect the transfer. Could you tell us what errors you are getting on the next steps as we might be able to infer something from that.

New Contributor
Posts: 2

Re: Copy Files task won't run in process flow

Posted in reply to ChrisBrooks

Normally when this task runs it says copied xxx bytes from x files to <location on server>. The following statement which errors is a proc import, which shoudl import the excel file that has just uploaded. But since the task didn't run the file doesnt exist. WHen I explicity run the task itself as opposed to the whole process flow it works fine.

Solution
‎09-22-2017 06:01 AM
Super Contributor
Posts: 460

Re: Copy Files task won't run in process flow

Posted in reply to dedwards96

I think you might have to raise this one with SAS Tech Support - there's just not enough information to go on from the log.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 166 views
  • 0 likes
  • 2 in conversation