Also, the ASSET_UID and CATCODE fields are varchar... so wouldn't trying to do a greater than on a varchar field not really work properly?

Sorry to hear that! I'd like to tell you that I remember but I honestly don't. 🙁

I did some research online for the error message and found...

Won't know the answer for that for a while. 🙂 The document I'm writing is a huge database enhancement recommendation compilation. The platform decision is just one section...

Oh my gosh! I can't believe I've never heard of or knew I could do that.

THAT is perfect!

I assume when you restore it, you just...

No, none of those issues...

How do you backup the database to more than one file? I did not see that option in the Backup wizard...

Ugh, don't ask why... its a horrible nightmare. It won't be in production or anything or nothing I'm doing as a "real solution". I also will not...

UGH!!! So close!!!

I think my file is 2.2 gigs.

Now I just gotta figure out how to do it... 🙂 I guess, first step, is...

Yes, I know if I went to an Oracle forum they would be pro Oracle. But I'm pushing a SQL Server agenda so I want the biased SQL opinions....

EdVassie (1/12/2015)

---

In the end it will be management that decide this issue, not technical people.

My advice is to talk to your management and find out what pressures they are under...

LOL you guys are funny. I also cannot stand the way Oracle handles dates and it drives me batty trying to convert them and actually get my queries to...

I understand there are nit noid things and its like comparing a Mercedes to a BMW but I need ANYTHING that I can stress to the customer (who is the...

Thanks for the replies, very good points.

I'm more looking for technical benefits.

Ok, I found the "delay validation" option and set it to TRUE! Whooo hooo... I was able to get it to execute from within BIDS after validating it.

Ok, so I gave up with C# ... VB is easier... lol.

I did this:

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic 2008.

' The ScriptMain...

aaron.reese (3/21/2014)

---

Firstly, Excel and SSIS will put you in a world of pain. Do you really need to use Excel as a source or destination. If you have...