Judith_Gitahi_1741

Promptset

Discussion created by Judith_Gitahi_1741 on Apr 18, 2017
Latest reply on Apr 18, 2017 by Peter WIRFS
I am trying to run SSIS package with date range parameter so I created a prompt set. The format has to be YYYMMDD, but for me to change the format from the default (YYYY-MM-DD), the calendar object needs to be set as a reference.
0sl3z477xp7v.png
h729d39m9u6z.png

I selected the calendar and chose EVERYDAY as the keyword, but when I try to select a date that's earlier than Jan 1, 2015, I get an error. I also have to manually type in the date as opposed to selecting the date from the calendar because anything later than Jan 1, 2015 is grayed out.

Start Date: Error in object 'JOBS.NAME prompt 'PRPT.DATE_RANGE': Input '2014-05-28' for Calendar 'CALE.FISCAL_CALENDAR', scope 'EVERY_DAY' is not valid.
 What am I doing wrong?

Outcomes