You can still use SSIS i believe. There is a file system watcher task that works like the .net code but you don't need to be coder to use. Link...

Correct if you are going to run the insert statement multiple times you need to add a where clause filter to only add in new records. There are many ways...

I'm glad I was able to help and hope you learned from the experience. Best of luck to you.

I'm not sure why you are using the Insert into ...Values .... You are not inserting specific values, but instead want to pass in the results from your select...

Try this Code. You'll need to add in the last few columns to pivot but if you understand the code it will take you just a few seconds to finish.

declare...

Forgive me if I'm not understanding its a dark rainy Friday and I'm fighting the urge to sleep 😉

It sounds like you want to take each value for the different...

Can you be more specific on sOperationtype result? You say Column 6 or 7 or 8 or 9 or 10 or 11 but what decides the "OR"? in your sample...

thanks Steve just as you posted i realized what you said. We were viewing the target size as the fileid.....doh! too late in the day i guess. Thank you!

Have you verified that the server still has that drive letter mapped properly? I would log on to the server and verify you can access this drive letter. If not...

I would typically have them append the date/time to the file something along the lines of XXX_01012010 where the XXX does not change. If your source folder for the csv...