Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Can't convert DT_NUMERIC to NUMERIC in SQL Server
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jack10063
Starting Member

5 Posts

Posted - 08/19/2013 :  10:53:25  Show Profile  Reply with Quote
Hi,

I am having problems to when I define column data type as DT_NUMERIC in Data Tools. I am reading in a flat source fíle, then replacing some columns using Derived Column with an expression: (DT_NUMERIC,18,10)(REPLACE(nominal,".",",")), then I have a Data Conversion where I have a data type DT_NUMERIC. But when I try to get the data into SQL Server I am getting an error saying that the data can't be converted. I have defined the columns as Numeric(18,10) in SQL Server. Everything works fine If I I define data type as FLOAT in Data Tools and in SQL Server.

Any ideas what am I missing? Is there a problem with my source file?

br,
Jack
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.39 seconds. Powered By: Snitz Forums 2000