Hi-I'm trying to import a .csv file into a database and continue to get errors messages. This the error message: Information 0x402090de: Data Flow Task 1: The total number of data rows processed for file "J:\Tammy\WID\CES\ces22.csv" is 701. (SQL Server Import and Export Wizard)

Information 0x402090de: Data Flow Task 1: The total number of data rows processed for file "J:\Tammy\WID\CES\ces22.csv" is 701. (SQL Server Import and Export Wizard) It's not an error message. It's an Information message. Nothing went wrong. You moved 701 records.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

I checked the destination table and nothing was actually transferred to the destination file. Here are the other two messages with it. Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "J:\Tammy\WID\CES\ces22.csv" on data row 1. (SQL Server Import and Export Wizard)

Maybe there is some row which has data type issue . Have a look at this http://sqlkit.com/2010/09/08/ssis-on-sybase-ase-15-loading-from-csv-file-to-untyped-table-and-then-to-typed-table/ You might have to build a SSIS and do a error redirect. If this is something you are doing for one time load try BCP command using -e switch http://msdn.microsoft.com/en-us/library/aa174646(SQL.80).aspxAshwani Roy Blog Twitter Please click the Mark as Answer button if a post solves your problem!

No, this is supposed to be a regular monthly update. So far, I have found out that the file I was to import had it's own errors in it and I've recontructed that import file. Now the import report says that truncation may occur. I know that I dont have to do anything with the text file coming in, b/c the text fields are a length of 50 by default, but they are not converting into the existing table structure in the database. I'm wondering if this is a roundabout way of telling me I have constraint violations? I'm going to backtrack on that for awhile and see if that checks out or not.