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 |
|
kris22
Starting Member
35 Posts |
 Posted - 2009-01-12 : 13:59:15
|
| Hi,I am trying to import the delimited file into sql server 2005 table and i am getting the following message at the design stage"the last row in the sampled data is incomplete the column or the row delimiter may be missing or the text is qualified incorrectly"i am using the BI to create the package. Can you guys help me how to proceed with this?Thx |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-12 : 14:29:55
|
| http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/f4ddf43a-39c8-49ad-96cb-cff4fa0b5636/ |
 |
|
|
Nagaraj
Starting Member
14 Posts |
Posted - 2009-01-15 : 04:19:47
|
| The last row of your flat file is not in the similar format as the other rows have. So try to change the format of the last record or ignore it..Nagaraj. |
|
|
|
|
|
|
Importing Text file into table