Thanks Mike! Which of those decrypt procs do you prefer? Or does it even matter?... I'll try it out and get back to you.

Pat

thanks. When I go to make changes to the MSins and MSupd sp's it gives me "invalid column name error" when I try to change the column name. It won't...

Thanks a lot, mromm. That was a great help. I'm still tring to learn the ins and outs of SQL Server, and have no one at work to ask questions...

Thank You!! I was making that a bit harder than it was. One more question, please?

What if instead of the CASE Statement, I needed to check both fields, for instance,...

Thanks for the responses. I got side-tracked. I'm still having trouble with this, and could really use some help.

Here is an example of a regular Update on the table I'm...

actually, they will usually be pretty small like 10 to 20 rows. You feel a cursor is better? Do you have an example? Thanks for the response.

Thank you very much. That was a simple trick, but would have taken me a while to figure out. Much appreciated.

-Pat

nevermind, I shouldn't have used set v = f.DateLastModified, just v = ....

Thanks for your help.

by the way, thanks for the link and the information, they were very helpful.

Thanks, guys. Here's what I tried, but I keep getting an error: Object Required: 'f.DateLastModified'

Here's the code:

Function Main()

dim fso

dim f

...

you know, I could swear I did that exact same thing before. I was changing some other things though at the same time though to. Maybe I got mixed up....

Hi,

I have the same problem, just need to check to see if file exists, and if so continue and rebuild tables, or else quit the package.If either of you could...

Thanks Robert. Yes, there's validation on both sides that manipulate the text file and the SQL table to always produce these char(8)length fields. I had thought this would be fine...

Sounds good, I'll test it all out. Thanks for all your help, especially the time comparison.

-Pat

Sorry, forgot this.

BEGIN TRAN

DECLARE @holiday VARCHAR

DECLARE @CurrentDate VARCHAR

SET @CurrentDate = convert(char(10),getdate(),101)

SET @holiday = (SELECT * FROM Holidays WHERE convert(char(10),HolidayDate,101) = @CurrentDate)

BEGIN

IF @holiday = NULL

EXEC cnvflag

END

COMMIT TRAN