Well said Steve! I guess when all is said and done......I'd rather my family have fond memories of family vacations than remember I was never home and always at...

We have a separate ETL server in our environment. It gives us the separation of layers as was stated earlier, but more importantly for us, it gives us one central...

We do a nightly backup before the ETL load as well. Just for reference, we use Idera SQL Safe backup software for all SQL databases. It has superior compression (up...

You can use a "no code" solution that is built into the SQL 2005 SSIS. There is an option on the first tab of the flat file connector that gives...

Wow are right about that!! It seems there is a troubling increase in "lazy" DBAs out there that don't seem to want to help themselves before posting questions here.

I have had luck in the past using Self-Test Software Test preps as well as Transcender exam preps

I do think that each of us is responsible for our own training and study (hopefully your company will help with the money for training and/or release time to study)....

I was hoping that someone had actually done a rename of a virtual server name following the BOL article http://msdn.microsoft.com/en-us/library/ms178083(SQL.90).aspx

My concern is that it's one thing to see...

Have you tried to rename the file with the date appended to the regular fle name??