I have done this a couple of ways over the years.

1. Using C# Script Task in SSIS with Arrays for the column headers and looping to find the header row....

You could try using TRY_CAST or TRY_CONVERT in your CASE but this will just hide the problem.

You're better to deal with the issue once then ignore it and deal with...

+1 Agree

Hi nsm2909,

Give this a try, it should get you started.

Note my figures are slightly different to your example as I truncated the timestamps in my table

;WITH CTE...

• This reply was modified 4 years, 9 months ago by  m-scally.
• This reply was modified 4 years, 9 months ago by  m-scally.

Have you checked this?

https://blogs.msdn.microsoft.com/euanga/2006/07/11/faq-why-does-ssms-take-45s-to-start-up/

🙂

I use Laptop for work, and like all of you will VPN / RDC into machine / server from home if warranted. I am lucky in that after hours work...

Thanks for doing the lead up work on this, it should be a good starting point for what I am working on 😀