Use COALESCE(completedDate ,lastSavedDate ,receivedDate )

Do you have any favorite links on the subject of pulling rather than pushing?

Hmmmm ...

Yes, I am replacing TRUNCATE with DELETE.  There are around 150 tables in total & for around 80 tables I have to reset the identity. Rest, of the tables,...

No need for double single quotes. Try this instead.

AND Name IN ('VS DAY Cash', 'VS Non Cash')

A) I've been using SSISDB logging for years now, so can't help you with that.

B) Not that I know of. You could add more debugging collection to the package itself...

It's difficult to troubleshoot this further without knowing more. I recommend that you do start using SSISDB - the 'free' logging that comes with doing this is enough on its...

How is that logging information being created? It looks non-standard.

Have you checked the All Executions logs to see whether there is any additional information there?

SELECT OBJECT_NAME(object_id)
      ,object_id
FROM sys.columns
WHERE name IN ('Column1','Column2','Column3')
GROUP BY OBJECT_NAME(object_id)
        ,object_id
HAVING COUNT(1) > 2;

Phil... where do you hail from?  I ask because I'm giving the "Automating "Excel Hell"" presentation at the Cleveland SQL Saturday on the 1st of February 2020 and would...

Are you missing a + before ".TXT"?

Phil... where do you hail from?  I ask because I'm giving the "Automating "Excel Hell"" presentation at the Cleveland SQL Saturday on the 1st of February 2020 and would love...

Unzipping files is natively available in .NET, so there should be no need to install additional software.

See here for more info.

Thanks, Eirikur, I've had a look into that in the past, now that you mention it.

If anyone has a handy chunk of code, working something like this (with suitable param...

This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column, unless I can guarantee the data....

Panic over 🙂 Happy new year to you too.