Just, a guess, but try checking out the scope of the variable. It may not be available during the For/Each loop process.

I googled your error and got this

http://www.pcreview.co.uk/forums/thread-2175408.php

It talks about a comcat.dll virus

Thanks Paul! I'll check it out and post my results.

Jerrfrey Williams Wrote

"Now if the times are entered  01/01/1800 19:00:00   (Start Time)

and the end time is entered  01/01/1800  06:00:00  (End time)

there is a problem. The end time is actually the...

Yep, thats what I thought.  Even though the size increased there are only about 20,000 recs in which the nvarchar data increased from 44 to 45 characters.

After a reindexing, backup, and...

Yeah, dealing with time as an integer is going to cause problems.  And even if you program a workaround you will probably end up having an issue when you wrap...

Nice job!  I like the changes!

Just a few things I've noticed:

1. Saving login info checkbox doesn't seem to save login info

2. I'm not a "Supreme Being" user as my profile...

Also check if the field is defined as CHAR.  If it is right-filled with spaces you won't be matchiing your pasted text.

When using Reporting Services tasks to export to a flat file destination you have to create a Flat File Destnation Task.  This task needs a Flat File Connection Manager to...

Hey, that's a good idea!  I can build up enough exes for a proper database record sampling!

Although, I don't think there will ever be a way to normalize that table,...

It depends on your motivation.  Since it's both fun and learning, try it both ways.  Keep your current structure and adjust primary keys accordingly, then play with setting up some test...

Are you constructing this project for fun or business?  The reason I'm asking is that if its a business project, you will save yourself alot of grief by taking the...

If you're using SSIS, as your post location implies, the flat file task has a check box to include header rows.  Just uncheck it.

I would remove the possibility of the unc path being an issue by using a local folder on the server.  This will make sure your tasks and packages work properly.  Then try adding...

Yeah, it seems SSIS wants you to anticipate your errors, which is ok if we know what they might be. 

I have a couple issues with SSIS and how these maximum...