I would be okay with messaging you a DB link to some dummy-ish data, but I don't think I'd want any of it out in the wild. Let me know...

I don't even have what the final version of these files will be yet. So, no table creation data either. I'd hesitate to waste any of your time on "evolving"...

Jeff Moden (6/25/2013)

---

"Load these files" how and where? I'm asking because one of...

I'll see if I can figure it out when I have some extra time. I'm most likely going to leave this SP as-is (at least for now), since it's working,...

For the simple file move, I agree with you. But I'm doing a bit more than that with the file name as a variable. I'm not sure I could easily...

opc.three (6/25/2013)

---

Gosh, that seems like a lot of code to move the newest file from one place to another. Here is how you would do the same in PowerShell:

$SourceFileSpec =...

A client is switching the way they deliver files to us, from emailing them, to a secure FTP. So, I wrote this and set it up as a SQL Agent...

Jan Van der Eecken (6/18/2013)

---

There's nothing wrong in the CreateProcessTable script, in fact you wouldn't be able to do this in any different way anyhow. Building the column list in...

They work. They've been in use for years. If there are errors, they're not fatal, and they haven't made too much of a mess of things.

The only data I...

Sure. Here you go:

https://www.dropbox.com/s/rkzv28ifjfgabed/SProcs_Erik.zip

Let me know if you can't get to Dropbox, and I'll just post the code.

Also, I only mentioned the table create cursor as an...

It's...

I'm replying to this mostly because the error I posted was such a quirky little thing that THIS post was coming up (on the only page of results) when I...

Hi Jeff,

Actually, after a day of on and off tinkering, the SP has changed a bit. I had to make a separate procedure on MSDB that the SP I posted...

That is neat. I'll mess with it some this weekend.

Thanks

Hm. Is it really necessary, or better, to involve another table? My ID column is PK/Identity, which in my mind at least, seems tallied already, or self-tallying? Something like that....