If you know Perl, and have connectivity, why not just copy each text file to your local machine? I'd consolidate the data on your one machine first. Make that a...

I guess I'm just not sure that encrypting really helps prevent theft of ideas. And it makes it entirely likely that you'll deploy the wrong version of something sometime because...

I'm not sure it's the weakest link, but it's a weak one. Brent had a good rant on things being buried, not clean, some dialogs getting lost (not in the...

I'd also trace to a file, set permissions on the folder for only someone auditing and the service account to write there, copy the files off to another server each...

I consider SSIS a dedicated ETL tool. It does things that you can't easily do in SQL Server otherwise, and even if it doesn't do everything that another tool does,...

What you're asking for is a lot of work. There isn't really a simple step by step guide to do this as it's a complex endeavor. I have some links...

Gail, you weren't that bad. I thought that was pretty nice.

If you know a bit, post what you know, or what you'd do, and then what you are confused about. As Gail mentioned, we don't do the work for you...

Never heard of it and I get a DNS error today. Perhaps it was a spam site.

Jason,

The blog image, is one that you configure in the "Change How My Blog Looks", not your personal avatar.

Please don't answer these questions for posters if they have not made any effort to understand or research. You are welcome to post links where they can learn.

Integration Services has OLEDB drivers to connect to other sources. If you can make a connection from the Windows machine to MySQL, you can build a package and send data...

Thanks for all the wonderful comments and I do appreciate them. Good to hear that we are doing some things right.

I'll push on the search to get something better...

JC is completely different in person, over a glass of wine than on the forums. I'm not sure why he acts that way, though he does appear to have mellowed...

You want an outer join, but you will likely need to simplify your query and build it step by step.

First, don't use select *. Pick up specific fields, as...