Thanks for replies solution worked great to move files.

Thanks again.

I found the issue it's the define of the Temp Table:

stamp_time DATETIME2(0) NOT NULL PRIMARY KEY CLUSTERED

If I just Define as datetime it works fine now...

THanks.

I would be interested to here if not using SQL Agent jobs to process the incoming data what method would you suggest to allow

processing of multiple Import records in parrel

Thanks.

The only difference is my Local PC I load off the c:\line_dumps on the SERVER there is a drive defined E: that I write the files from the PS script...

1. yes
2. Yes

3 yes

It's weird that If I run my PS script on SERVER then copy files down to my local PC they load. If  I copy files from my...

Could the issue be OS related our not running from the root C:\???

very strange error of the PK on the temp table  .. data looks correct

I had a file that just 10 records all of them had a date of 7/14/2021 with different timestamps. I could see all of the records in NotePad++ so I...

The file I'm processing has yesterday's dates...

@jeff

Had a strange error processing file from server...

It was the first file that had data...

StartDT: 15 Jul 2021 08:44:42:777

Working on file 25 of 89 files: G:\line_speed\F303-Line10.csv...

Msg 2627, Level 14, State...

Backup of file:

$date = get-date -uformat "_%d_%m_%Y_%H%M%S.bak"

$newname=($csv -replace ".csv",$date)

Rename-Item $csv $newname

Count:

$count=($csv).Count

$count

Can I just add this to the bottom of my script?

Thanks.

I have this script working, but would like to add a few features.

1) backup original xls file at the start of the process with a datetime stamp

2) produce-record-count-of-data-processed.

Thanks.

            
July 12, 2021 at 11:42 am
            
#3906925

            
            
                                                
        

I need to measure how many records I'm processing in my Import table which has a Date field(DATE) and a Time(Time(7) field.

I like to know records per minute and records...

I'll like to find a solution without loading the driver..

What file do I need to Install the "Microsoft.ACE.OLEDB.12.0" driver...

You are correct Jeffrey when I try to use a PS script to import the data, it's getting confused on columns from csv versus

sql Table.