Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chinna8143
Starting Member
2 Posts |
 Posted - 2008-02-18 : 19:43:12
|
| hello ...i me new to sql server will u plz help me out in this issuei 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)MessagesWarning 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 |
|
|
|
|
|
plz urgent in import/export