February 18, 2008 at 5:16 pm
hello bro i have got an error while importing data from flatfile to sql server the error is when i tried to import data from flat file to sql server which is in comma delimited format i m getting this error ...in this if i have 25 rows in flatfile i m jus geting 24 rows inserted will u plz tell me how can i solve this issue i am using import/export wizard to import data...the data is in .csv extension and comma delimited...i have gt an error .....so and moreover i have appended the data to an existing table so how oculd i jus add the remaining row or what would be the solution for this do i need to do all the import again ,.....
- Executing (Success)
- Copying to [Kms_Roxane].[dbo].[Chargebacks1997_Roxane] (Stopped)
Messages
Warning 0x8020200f: Data Flow Task: There is a partial row at the end of the file.
(SQL Server Import and Export Wizard)
Information 0x402090de: Data Flow Task: The total number of data rows processed for file "\\Syndevsql\DAS\Roxane\1997-112000 Roxane\Chargebacks2000_Roxane.csv
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
February 18, 2008 at 9:11 pm
How about adding an end of line mark (LF/CR) at the last row (line 25)?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply