Wrox Programmer Forums
|
BOOK: Knight's Microsoft Business Intelligence 24-Hour Trainer
This is the forum to discuss the Wrox book Knight's Microsoft Business Intelligence 24-Hour Trainer by Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc, Mike Davis ; ISBN: 978-0-470-88963-3
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Knight's Microsoft Business Intelligence 24-Hour Trainer section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 4th, 2010, 12:44 PM
Registered User
 
Join Date: Nov 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 8 table build script

I had this experience in Chapter 8. When I was going through the SDC wizard I could not map the discount percent. When I tried I got the following error.

Cannot map columns of different types.
Column 'DiscountPct' is of type 'System.Decimal' and column 'DiscountPct' is of type 'System.Double'.

I changed the data type in the build script to SmallMoney to match the source table and everything worked fine. Then for fun I changed the script back to use a float and recreated the table and the packages still executed. However If I re-launched the SDC wizard I could not map the Discount percent back up.
 
Old February 12th, 2012, 08:49 AM
Registered User
 
Join Date: Jan 2012
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default metadata

hi I thing because when you open the sdc wizard, it checks fort he metadata of the input/output columns and found the inconsistency... if you run it doe not check that and probably it will inject some rounding errors because smallmoney has a different precision rather than float.... [even it seems float is more rpeciese than smoney ]

http://databases.aspfaq.com/database...c-columns.html





Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Pivot Table Build Issue baycolor Excel VBA 0 March 21st, 2008 10:15 AM
Cant compile or build on chapter 3 stzd8 ASP.NET 1.x and 2.0 Application Design 4 October 30th, 2006 03:01 PM
C# - Chapter 3 Build Error TJ BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 July 29th, 2006 03:43 PM
Build a table from a Stored Procedure rogue248 SQL Server 2000 2 October 7th, 2004 10:06 PM
Linking form and a table that are build separately takawera Access VBA 2 October 8th, 2003 10:18 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.