That is great info for a newbie like me! Thanks so much for helping out!

Shree

Oh...I see what you mean. I can now figure out what the rest of the stored proc is doing based on these dates. Thanks a lot!

Shree

Thanks so much for helping out. I will use the syntax posted in the solution.

Here is the part that I had needed help with in my where clause...

(where (timesheet.wcstart...

Thank you so much for your time and detailed instructions. It worked this time!

Thanks again.

Shree

Hello again,

I tried using the select node approach but I dont think I am using the correct syntax. I used a code sample from http://support.microsoft.com/kb/318499 for this but...

Thank you so much. I will give this a try and post a reply when it works!

aah...as you can see I am really a newbie at writing queries. Thank you so much for your help!

Shree

Thanks for the reply, I had tried the (site = 'M' and career_level <> 'u') but I get only students on Campus M who are not undergrads with that.

How...

Thanks! Now I have divided my task into two "Execute sql steps"

1. Backup a db

USE rmsReal

GO

BACKUP DATABASE rmsReal

TO DISK='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\BU_remReal.bak'

Go

2. Restore it as a different db

RESTORE...

The Execute SQL task gives an error saying I need at least one connection. What does that mean?

Thanks

Greg,

Thanks for your help. I am trying to automate this process and was wondering how to do that.

Thanks,

Shree

I tried that but I am still getting the same error. Is there any other way for me to clean the txt file before I bring it in using DTS?

Thanks

Hey,

Never mind! I just found out I needed to set the object to Nothing

set oFSO = Nothing

That worked!

Thanks!

SD

When I tried to save the script, it is giving an error.  It says that the job was not saved because all objects that were created were not destroyed.  The error code...

Thanks for your help! I really appreciate it.

SD