Thanks Jeff. Its SQL Server 2017.

Example list of appointment dates from the Appointments Table (many records will have identical Appointment Date) as multiple clients will have appointments on the same day to each other:

So the Appointment Table will contain records with multiple entries for the same date (i.e. different clients having their appointments on the same day). I have given a sample list...

• This reply was modified 8 months, 2 weeks ago by Reh23.

Thanks, Phil. Resolved !

I have converted all the dates to ISO format, but the Job is still failing.

Thanks Phil.

SQL Tables are being used to populate newly created Excel files during the execution of the SSIS package. We are NOT transferring any data from any MS Excel File...

• This reply was modified 2 years, 4 months ago by Reh23.
• This reply was modified 2 years, 4 months ago by Reh23.

Unfortunately the above does not work either, that is, I tried coding FORMAT( @d, 'yyyy/MM/dd', 'en-gb' ) for each Date field in every SQL Script in the SSIS package.

I also...

As "SETDATEFORMAT ymd" did not work, I then tried to modify each date field being used throughout the package with the following function:

FORMAT( @d, 'yyyy/MM/dd', 'en-gb' ) AS 'Date'

• This reply was modified 2 years, 4 months ago by Reh23.

Thanks. I tried adding this line at the beginning of the SQL Script in the package:

"SET DATEFORMAT ymd;"

But gave me error (similar to the one I am getting when the...

• This reply was modified 2 years, 4 months ago by Reh23.
• This reply was modified 2 years, 4 months ago by Reh23.

I did not create it, but simply run it. I was only trying to automate the running of it in a SQL job agent.

It makes a copy of an existing...

The purpose of the Application is to provide two different forms (based on the Permissions level of the one using it):

1. For normal users to use it as a form...

T-SQL. Thanks for notifying me about the Jo Celko article ! Sorry - what is the link for the article you are referring to ?

• This reply was modified 2 years, 8 months ago by Reh23.
• This reply was modified 2 years, 8 months ago by Reh23.