Hi

I am facing a weird issue and need your help.

At one of our client side when we run ssis package through UC4 (scheduler i have no idea )  the date implicitly converts into YYYY-DD-MM format and this is why our package is failing,

The culture setting of server is US English.

When I  run the package via batch file (dtexec command) the package runs fine and date is correctly parsed as YYYY-MM-DD (as expected)   but with uc4 it is giving problem.

If you have any experience with UC4 or any idea/ experience  about this problem please assist.

UC4 scheduler code is also inturn generating dtexec.

I think regardless, you will end up with a modification to the package to work with the YYYY-DD-MM format which is unfortunately a non-ISO date.

Hi Kunal,

Based on your description, the package runs via batch file (dtexec command) fine and date is correctly parsed as YYYY-MM-DD (as expected), but with UC4 it fails with date converts into YYYY-DD-MM format.

It seems that the issue is caused by UC4 Scheduler that convert the date format. It is related to UC4, since I have never use this scheduler and it is out of the support boundaries of our forum, I suggestion you post the question in the following forum: https://automationpassion.com/uc4_login.do?sysparm_doctype=true. It is appropriate and more experts will assist you.

Thanks,
Katherine Xiong

Hi Arthur/ Katherine,

Thanks for your support, Ill take it up with UC4 .