RobertKing
Reputation: 1921
SSIS Loading data from csv file to sql table
I am loading data from csv file to my sql table through SSIS. Is there any default limit specified on number of records to be read from csv file ?
While loading the csv file, my data flow component is processing only 5000 records, though it contains 5341 records,as shown in the image below.How can i fix this ?
Upvotes: 0
Views: 490
Answers (1)
gvee
Reputation: 17161
Are you [mistakenly] swallowing error rows?
What have you got set in the source error output?
Upvotes: 0
Related Questions
- Import a CSV comma-delimited file into a SQL Server table
- SSIS CSV File load to table
- SSIS - Load CSV files located in SQL Server Table
- ssis - load multiple csv with different structure to sql server
- Load table on SSIS with CSV files
- Loading Comma Separated csv file to table in SSIS
- What is the best way of loading different csv files into different SQL Server tables using SSIS?
- SSIS, Importing multiple datasets from one CSV file
- process csv File with multiple tables in SSIS
- SSIS - CSV to SQL Server Data Import Error