Can you send a more full blown version, and how I get(download) dbatools. I went to the page but didn't see how to download.

Many thanks!!!!

Not sure I'm following convert to time

Thanks,

Found that I had to use '1969-12-31 20:00:00' to get the correct datetime. So I'm looking for the most efficient way to pull the last 30 minutes of data from...

I'm checking now the data

Thanks.

I was thinking UTC  if I use your query that sets an EndTime data looks correct..

I just pulled one of the latest records written to table and when I convert it it shows 2021-06-15 19:53:37.000

THanks.

That looks correct to me, but I'm getting records with dates past even current date time. I'm checking on the process writing records to

the table, but something is a miss...

This gets me the date from the table:

DATEADD(s,t_stamp/1000,'1970-01-01 00:00:00') ..  I want to extract data 30 minutes prior from current datetime using the expression from t.stamp field  ... maybe I...

Do you ever use the tool from dbatools Import-Excel for Powershell?  I tried creating csv's out of them then loading the csv

to SQL, but some columns contained commas in descriptions...

That was a super fast load process... Just wanted to thanks again ... very impressive and well documented SP

Just a side question, what process do you choose to load xls...

Awesome!!!!...

I'll get some time today to run it thru it's paces ...

Many Thanks

Did you have an free time to complete?

Thanks,

Still on the radar?

Thanks.

I was thinking on the table and I would like to make separate columns for Oven and Line..

1. Move successful file loads to a completed dir.
2. 40-50 thousands records per file.
3. Bad rows maybe logged to exception table with file name that they came from.

            
June 7, 2021 at 12:54 am
            
#3892711