Hi all
I am using DTS package to export data from SQL Server 2000 to .dbf file.
Problem is that FLOAT or NUMERIC (dbase Data Types) are mapped to SQL_DOUBLE (ODBS SQL Data Type) by default.
So, When I create DTS package in SQL server and create a dbf table, it converts numeric into double.
As a result, when export is done all my integer values appear as double in .dbf file.
Can anyone please recommend any solution for this
Thanks!
Regards
< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
DTS package Export - from SQL to DBF
Hot Topic
- Full Text Search (2005) - How to determine word offset in CONTAINS query?
- CAST function problem
- ExecuteSQL task has changed
- Sql Job failing with MSDTC has canceled the distributed transaction.
- Error attempting to import from Excel
- SQL Server data types
- Adding an Image
- I need SQL Server2005 Standard Edition with my SBS2003R2
- How do I return a TRUE or FALSE using a Stored Procedure?
- SSIS Tutorial Lesson 1: Debug Error
SQL Server
- Monitoring the running and execution of SSIS packages with MOM
- Data Trasformation Services
- SSMS Express: Create TABLE & INSERT data into table - Error Msgs 102 & 156
- SQL 2005, multiple instances - what about ports?
- Adding Table to Dataset for SQL Server Mobile causes VS 2005 to lock up.
- Shading By Value
- Identifying the ErrorColumn (in rejected data rows)
- SSIS and COM
- Execution of queries on tables without table owner specified fails.
- Separate date and time datatypes - come on guys!
DTS package Export - from SQL to DBF