Please Help Me I Am Retarded

Oct 28, 2004

ok, I admit this might be a stupid question, but I can't help it...I really don't know the answer to this:

I have a VBScript script that receives a floating point number from a form. I'm using a stored procedure to save this information to my SQL database.
My DB table field is set to "float" and my stored procedure variable is "float" but my vbscript variable is a double...and this combination doesn't work.

I need to know what variable types to use so this combination works and I can successfully store my decimal number in the database. Does anybody know this??

thanks!
~hJ~

View 3 Replies

I'm Retarded And Need Help With Derived Column Or Script Task

Feb 2, 2006

I am moving data from an oracle database to sql server. Two of the source fields are dates, which sometimes contain values I know to be incorrect ('0001/01/01' and '1900/01/01').

I'd like to use either the derived column or script task (or any other appropriate one) to update these incorrect values (in both columns) to null before inserting into sql server, smalldatetime field.

In sql 2000 dts, I would simply use a VBScript IF statement, but I'm somewhat clueless when it comes to .Net.

Does anyone have any ideas or sample code that may help?

Thank you much.

View 5 Replies

View Related