Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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.
Reply With Quote
  #2 (permalink)  
Old February 12th, 2012, 08:49 AM
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Location: dublin
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 02:03 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.