Derived Column return WRONG datatype.

Hi, friend,
l've 2 variables A & B from source database which i used to calculate C with the following formula, i.e.

C = 100 * A/B

In case of B = 0 (DIV BY ZERO), C should be equal to -9999.

l've set the datatype for A & B are INT, C is FLOAT at targetting database.

So l used to derived column to calculate C as,
B == 0 ? -9999 : 100 * A/B

After l run the package, l realize that all my C is INTEGER rather than FLOAT.....it seems that SQL server has evaluate the wrong datatype for me....anyway to overcome this?

This should not be a problem - you can map an integer in the data flow to a float at the destination without any issues.

Donald Farmer

|||Fact is, l get a Integer at the end :(, even the data and meta data is float........
|||

Try casting A and B as floats before using them in your calculation.

-Jamie

Deployment / Version Questions

I'm going to write an application for a friend's business using VS .NET and
SQL Server 2000. I'm confused though as to how I can write everything on my
laptop, then copy to their server. I have an MSDN subscription and did not
realize that I cannot install the Enterprise Edition of SQL Server on XP
Pro. I can install the development edition, but am I then going to run into
problems trying to copy it over to their server?

My experience lies in Informix / DB2 and Java / JDBC, so this is new
territory for me and I appreciate the help.

Derrick LathemHi

On your the destination you will have to install a new copy of SQL that is
correctly licenced. In general I don't think your MSDN licence will not
cover their systems, although you may be able to distribute MSDE. You should
read http://www.microsoft.com/sql/techin...eskChooseEd.asp to
see which edition is most appropriate for your needs. For MSDE check out the
web site http://www.microsoft.com/sql/MSDE/

To get your database onto the destination system there are several ways, the
easiest is probably to detach/attach the database, but you could use one of
several other methods see:
http://support.microsoft.com/defaul...b;en-us;Q314546

You should also make sure that the logins are correctly set up on the
destination system.

John

"lathem" <lathem@.ns.mindspring.com> wrote in message
news:yA3Ob.11830$i4.10805@.newsread1.news.atl.earth link.net...
> I'm going to write an application for a friend's business using VS .NET
and
> SQL Server 2000. I'm confused though as to how I can write everything on
my
> laptop, then copy to their server. I have an MSDN subscription and did
not
> realize that I cannot install the Enterprise Edition of SQL Server on XP
> Pro. I can install the development edition, but am I then going to run
into
> problems trying to copy it over to their server?
> My experience lies in Informix / DB2 and Java / JDBC, so this is new
> territory for me and I appreciate the help.
> Derrick Lathem|||To add to John's response, the SQL Server Developer edition provides the
same features as the Enterprise edition but is licensed only for development
use. This is the appropriate choice for development if you are targeting a
server edition of SQL Server. It is included with MSDN Universal and
Enterprise subscriptions or can be acquired separately for about $50.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"lathem" <lathem@.ns.mindspring.com> wrote in message
news:yA3Ob.11830$i4.10805@.newsread1.news.atl.earth link.net...
> I'm going to write an application for a friend's business using VS .NET
and
> SQL Server 2000. I'm confused though as to how I can write everything on
my
> laptop, then copy to their server. I have an MSDN subscription and did
not
> realize that I cannot install the Enterprise Edition of SQL Server on XP
> Pro. I can install the development edition, but am I then going to run
into
> problems trying to copy it over to their server?
> My experience lies in Informix / DB2 and Java / JDBC, so this is new
> territory for me and I appreciate the help.
> Derrick Lathem