(1000000 row(s) affected)

===== Rounding method 2 ======

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

373...

Looking back at my code, its semi-generic.  I can see a few more changes that would need to be fixed to make it more generic and useable for any three...

I see one possible problem using dayofyear; leapyears.  February 29 of a leapyear is the same dayofyear as March 1 of a non-leapyear year (confused?).

We don't have our QA/Production systems yet, but we have setup our SSIS Packages to dynamically configure the connections using information stored in a Configuration Database table.  The only fixed...

I guess it really comes down to the volume of data you have to process and your requirements.  It's always good to know different ways of accomplishing a task, so...

Some say it is faster than converting to/from varchar.  I have done some testing and it is sometimes faster but sometimes slower.

In our process we put *.txt in the arguments property as we have multiple files to zip.  This is where you may want to put the the name of your...

Also, I am reviewing all of our posts to make sure I know where we are, as I don't want to leave out a step.

I'll get back to you on the errors you are getting, I need to look at them a bit but it may be a bit before I can get back...

There is probably an error in your package somewhere.  SSIS won't let you run your package if there is a design time error.

Did you find where 7-Zip created the original zip file?  What is the setting for RequireFullFileName?

Checking our setup, RequireFullFileName is false, Executable is gzip.exe.

On the server, I made sure that...

I did think of one thing, what did you set the working directory to in the Execute Process Task?  That should be where the zip file would be created.

Two things.  One, I don't know your zip program so you will have to read the help files for it to figure how to use it.  Second, we really have...

This may also be a good time to explore upgrading to SQL Server 2005 where you can actually store XML data using the new XML data type.

Thought I'd check and see how your zip process is coming.  I will take a bit of time and work on the next two pieces of your puzzle for renaming...