This brought back memories of choosing a reporting package to handle our increasing need for reports (prior to SSRS ). We brought...

Could also consider using PGP over FTP. That was enough to satisfy our auditors. We used GnuPG for the PGP solution (with a front-end called WinPT for easier...

I did this quite a bit and worked with a couple of different things. Generally, I was able to get a command-line sync tool (don't know if CuteFTP has...

Probably the best I can offer is to do some searching. There are two pretty good SSIS books out right now. There's http://www.sqlis.com. Jamie Thompson...

You'd use SQL Agent to schedule the package to run. You may have to save it with some form of encryption in order to save passwords, but I'm not...

For me, one of the lawn-mowing robots would be great - I hate having to mow or pay someone to do it for me.

As for the defense robots, I imagine...

If it's purely along the lines of:

Select data

Aggregate

Insert

You may be able to just link the servers and set up a couple of stored procs...

Page navigation at the top of the screen would also be a welcome feature. If I'm either returning to a topic or want to jump to the last page...

Well, as a long-time reader/lurker, I like the "second look" idea. That's been missing for a while. Perhaps even break this down into "most read" vs. "most commented"....

Step by step for this would be kind of hard as we don't really know your system details, but in a generic sense it would be something like:

Define Source Connection...

If you can link to the file as a linked table, you can pull it in via Access using that linked table. Not wonderful, but I've used it before....

Well, I will return to my first suggestion, then - Monarch. It still requires some work, but if you get the slightly more expensive version, it can be driven...

Sam, you're best bet really will be Monarch in this case. It's not easy, but it is designed to take these human-readable text file reports and put them into...

Not that I could see. When I exported to Excel and re-imported the missing records, I didn't see anything odd with the data. I just noticed that it...

Thanks for that bit of information, Jamie. That's going to make a lot of my default mappings quite a bit less painful. I was always changing the nvarchar...