Integration service numeric error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Integration service numeric error

Hello,
I developed a package en SSIS in Windows XP. This package generate a table that it contain various field numeric (decimal), but when I ran my package in Windows 2003 server (sql server 2005) my data have problem : numeric field don´t appear incorrect , for example, 2.64 appears 264.0000, This problem seems related with regional and language option,Thanks for any suggestions! Oscar
Thats more of presentation layer, have you checked the destination column data type & precision in this case?

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |