In Object Explorer in SSMS, Right Click on the Database, and select Generate Scripts.  The wizard will walk you through generating what you are after.

I partly agree with that, but some else has heaped some fuel on it as well (not you, Jeff).  I got some good info that could come in handy.

And the flaming starts again.  I think the professionalism of this site is starting to wane.

(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.