SSIS Task - File not found - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

leonk
No customer Topic Starter

12 years ago

I am trying to run an SSIS task and getting the following error message:

File not found: C:\Windows\TEMP\VisualCron\a61ed8b2-a1cd-4f0b-8d02-82599ecdaeb2.xml
Exception in Task: Non zero exit code

The file does exist on disk in the above location. Could this be a permissions issue?

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official support

12 years ago

Yes, it could be, please make sure the SYSTEM account (local system) have access to read that. But it should have as it is the SYSTEM account that has written the file.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

leonk
No customer Topic Starter

12 years ago

Hi Henrik

Thanks, not sure I understand your response. Is there any reason the local system account would not be able to access this file if it created it?

The SSIS task is configured with credentials of a user who has access to the SSIS server, does this make a difference?

Support
Official support

12 years ago

I do not see a reason directly and I have never seen this before. This is just the normal temp folder. Check if local system have full permissions here.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

leonk
No customer Topic Starter

12 years ago

Originally Posted by: Support

I do not see a reason directly and I have never seen this before. This is just the normal temp folder. Check if local system have full permissions here.

Just confirmed Local System does have full permissions to the folder. Screenshot attached. Is there anything else I could be doing wrong? The task exit code is 77777

leonk attached the following image(s):

Support
Official support

12 years ago

Do you use integrated authentication in your SSIS Task?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

leonk
No customer Topic Starter

12 years ago

Originally Posted by: Support

Do you use integrated authentication in your SSIS Task?

Sorry for the late reply.

Yes I am using integrated authentication.

I've changed the temporary folder location which has resolved the 'file not found' issue. I'm now getting other errors which may indicate a connection problem between the SSIS server and my VisualCron server.

Support
Official support

12 years ago

Which exact error do you get now?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

leonk
No customer Topic Starter

12 years ago

Originally Posted by: Support

Which exact error do you get now?

"Non zero exit code"

Full task log attached.

leonk attached the following image(s):

Support
Official support

12 years ago

#10

Try using an IP instead of dns name of server.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

leonk
No customer Topic Starter

12 years ago

#11

Originally Posted by: Support

Try using an IP instead of dns name of server.

Same error. I have verified from another instance of visualcron with better network access to the server running SSIS and it's working fine.

Side issue - now having problems adding variables to my SSIS task in VC since upgrading to 6.1.7. I can click the 'Add' button, enter details, however when I click 'Ok' nothing happens.

Support
Official support

12 years ago

#12

About adding parameters, we just fixed this in this version:

http://www.visualcron.co....aspx?g=posts&t=2890

Thanks for the report.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!