Well, He has the logic, and the theory behind it.  Now he has to apply it and adjust it to his environment.  I have asked for help, gotten advice, applied...

From his first post:

If we use today for example (Thursday) we would add 6 days to the 21 days. 

That looks like a totla of adding 27 days to todays...

Based on what he was looking for, 2006-12-06 is the correct answer.  Found the next Wednesday meeting and added 21.  If you wanted the third Wednesday, change the 21 to...

I majored in Computer Science, I minored in Mathematics.  Looking for patterns and solutions to them seems to come easy, especially when math is involved.

Hope this helps with what you...

How the whole thing works:

Based on Sunday as the first day of the week:

Day     Num Days to Add

Sun     1      3

Mon     2      2

Tue     3      1

Wed    ...

I could try to explain how they work, or better yet, I could just have you read BOL first and then if you have any questions, we can can talk. ...

Can't help much on the mass update, but I would suggest doing a search on this site for articles about portable DTS packages.  In developing a prototype data warehouse, I...

Try the following (it assumes the following default: set datefirst 7 (Sunday is the first day of the week)):

select dateadd(d, (7 - ((datepart(dw, getdate()) + 3) % 7) + 21),...

In your data flow where you load the data, you would add a lookup task.  You want the records where the lookup on the unique id fails to flow through...

The domain accounts running our SQL Servers have admin rights.  I would also make sure you have another user with sys admin rights besides your own account, not just in...

It should.  However, I would recommend that you backup to a local drive and then copy the backup file to the network share and then if needed delte the local copy...

Your destination should look something like this:

\\servername\sharename$\dbbackupfile.bak

If you have a space in the file name, you may also need to surround the entire destination string in double quotes.  Personally,...

And what about the filename for the backup file?  What is it?

What exactly are you entering in the destination, and how are you entering it?

Post the SQL command you are using to backup your database.  It will help in debugging the error.  Also, be sure that the user that SQL Server runs under has...