TOKEN?

I had not heard of that one. I shall have to try it.

Whee HAW!

We survived! The big migration from system A to system B is completed and we ran a month end on the new system with few issues. Everything mostly...

There are a couple of ways you can do this.

1) Build the file import connection manager to treat date and time as two separate import columns. This is...

And once you do what Grant instructed, if you still get the error, you need to look at the backup tables in MSDB to find out what the correct "earlier...

So I thought this was solved, but the code I can run in the Powershell UI doesn't want to run in a SQL Job Step.

Any thoughts on this...

For anyone else who reads this thread later, it helps to put a file existence check around the file move. Otherwise (as I just found out) the job step fails...