The question is misleading:

I need to assign this value from a...

If you leave off the sub-seconds and do not include a period - Excel should display it correctly.  This appears to work just fine: convert(char(19), getdate(), 121).

The question is a bit misleading - as it mentions a concern about the time zone (which isn't actually part of the string - the string contains an offset which...

Hi Jeffrey, many thanks!

I have the column in my table telling me the last time rows were added.

I guess I could use that one, but if I do, isnt...

My recommendation would be to convert to project deployment - install and configure Integration Services Catalog - and rewrite/rebuild your packages as projects and deploy to the catalog.

The benefits far...

When using the ISO format YYYY-MM-DD in SQL Server on a British English language and converting (implicit or explicit) that value to a datetime data type - it will be...

Do you have a table that tracks your data loads?  That table should have a date/time column that identifies the last time the load was processed and completed successfully.

With the...

From 2008/2012 (package deployment model) to 2019 - export the packages to the file system, create new projects, add packages - modify packages to work in project deployment model, deploy...

You asked if there are other ways to accomplish your goal - and yes, there are several...all of which start outside SQL Server.  Two (of the many) methods are:

1. SSIS

...

That is very similar to how I process files - but I am getting the date from the file name.  I also did it the long way - using an...

Interesting approach - it doesn't have to be the best as long as it gets the job done.

Are you using SSRS for the reports - or something else?  If SSRS - then you have the option of using shared datasets and can control when and how often...

As stated in the other thread you posted to - the problem is that SQL Server Agent uses tokens, and tokens are defined by $(token).  Since your code has this:...

Just to point out - you posted to a 2 year old thread.  This really should be a new topic...

With that said, this issue was explained very well by Shawn...

Using a script task - you can loop over the files, read the first 2 rows and build an array - sort the array as needed and return only the...