Hello
I am trying to load data into MS Sql server BIGINT field
it is constantly failing with Can't convert value 201004210101231 to BIGINT for field CustomerID
Here is the ETL transformation log:
Information 24/04/2010 13:01:46 Starting...
Information 24/04/2010 13:01:46 Target Table: [DEMO].[dbo].[Customer]
Information 24/04/2010 13:01:46 Trasnformation Type: ADD Records
Information 24/04/2010 13:01:46 delete from orders
GO
Information 24/04/2010 13:01:46 Path: C:\Testing
Information 24/04/2010 13:01:46 Mask: Customer.csv
Information 24/04/2010 13:01:46 Found: 1 File(s) to read
Information 24/04/2010 13:01:46 Reading all files
Information 24/04/2010 13:01:46 Source File: C:\Testing\Customer.csv
Error 24/04/2010 13:01:46 Can't convert value 201004210101231 to BIGINT for field CustomerID
Information 24/04/2010 13:01:46 Read 4 Line(s)
Information 24/04/2010 13:01:46 Processed: 4 Record(s)
Information 24/04/2010 13:01:46 Records per second: 14.86
Information 24/04/2010 13:01:46 Rejected: 1 Record(s)
Information 24/04/2010 13:01:46 Inserted: 3 Record(s)
Information 24/04/2010 13:01:46 Updated: 0 Record(s)
Information 24/04/2010 13:01:46 Deleted: 0 Record(s)
Information 24/04/2010 13:01:46 Filtered: 0 Record(s)
Information 24/04/2010 13:01:46 Time Taken: 00:00:00
Information 24/04/2010 13:01:46 Transformation is finished
Sen
