Viewing 15 posts - 25,696 through 25,710 (of 26,487 total)
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.
July 10, 2007 at 1:24 pm
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.
July 9, 2007 at 8:39 pm
And the flaming starts again. I think the professionalism of this site is starting to wane.
![]()
July 9, 2007 at 8:10 pm
(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...
July 7, 2007 at 4:20 pm
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...
July 6, 2007 at 3:03 pm
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?).
July 6, 2007 at 2:04 pm
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...
July 6, 2007 at 11:14 am
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...
July 6, 2007 at 11:07 am
Some say it is faster than converting to/from varchar. I have done some testing and it is sometimes faster but sometimes slower.
![]()
July 6, 2007 at 8:57 am
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...
July 5, 2007 at 5:07 pm
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.
July 5, 2007 at 2:53 pm
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...
July 5, 2007 at 2:51 pm
There is probably an error in your package somewhere. SSIS won't let you run your package if there is a design time error.
![]()
July 5, 2007 at 12:56 pm
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...
July 5, 2007 at 12:43 pm
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.
July 5, 2007 at 10:23 am
Viewing 15 posts - 25,696 through 25,710 (of 26,487 total)