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 |
|
chilluk
Starting Member
24 Posts |
 Posted - 2007-08-28 : 11:53:18
|
| I have a simple flat file which I am trying to import which has 50k rows and about 50 columns. File is delimited (using a rather obscure multiple char delimiter) with text delimiting also.When importing if I check the "Retain null values from the source" it will import the columns correctly but drop approx 7k of the rows.If I uncheck this box it imports all rows, but on the second integer column in that target table all values are inserted as zeroes when there is at least 35k rows with a positive value.I have put a data viewer on this import and it's also showing zeroes.I'm tearing my hair out!! |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-29 : 08:17:03
|
| Import it to Excel first, check it all looks OK, and then import that to SQL Server perhaps?Kristen |
 |
|
|
chilluk
Starting Member
24 Posts |
Posted - 2007-08-29 : 08:54:29
|
| Yeah it all looks fine and dandy in Excel - trouble is this job runs 5 times a day so can't do that all the time.I managed to get it going for now by crunching each and every bit of whitespace out of the file - touch wood at present it's OK. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-29 : 09:01:29
|
| Possible Control-Z in the file, and being treated as EOF, and somehow only acted upon when using the "Retain null values from the source" option? |
|
|
|
|
|
|
Dropping Integer Values