May 27, 2016 at 3:23 am
Hi,
I am building an SSIS package to import 8 columns. The number of rows to import is 3650. I have tested the SSIS package import column by column. I have a column field with 2 characters e.g. CO
When I run the package with 4 columns it all 3650 columns import, however as soon as I add the 2 field column with a char (2), it only seems to import 2605 rows.
I added another column on with an integer field e.g. 02. The import now moved up to 3605.
Does anyone have any ideas on what is causing this?
Regards
May 27, 2016 at 3:31 am
Assuming your source is flat file, what is your row terminator?
Is the row terminator is present in those column values?
May 27, 2016 at 3:47 am
There is no row terminator present. I am using a CSV file.
May 27, 2016 at 4:33 am
What are the data types for the columns on the CSV?
Sounds like a column is numeric and wont import a char.
Jez
May 27, 2016 at 4:53 am
Not enough information to figure out whats happening. What you could do is import both results to two different tables and figure out the the row the first 4 columns values start to change, this will help you study in detail what happens in the previous row.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply