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 |
|
gsolares
Starting Member
7 Posts |
 Posted - 2008-10-23 : 14:48:54
|
| I have a simple DTS package that uploads an xls file into a table. There is one column where the first 125 items are blank but all the rest (about 5000) have info. The uploaded information is showing NULL values for all items on that column.Here is the kick, if I add info on the first ocurrance of that field on the xls file and then I upload, all the values of that field are uploaded correctly.Any ideas?Thanks,GS |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-24 : 08:37:50
|
| It's because at this time the wizard looks not at all rows only the first few (don't know how many) rows are checked to get the required information for the next steps...It's a known problem.WebfredNo, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
gsolares
Starting Member
7 Posts |
Posted - 2008-10-24 : 10:43:32
|
| Thanks Webfred,So this means there is no known solution for this known problem?Thanks,GS |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-24 : 11:08:24
|
| I don't know about a solution.I think you are not looking for a workaround that requires manually action...But it's at least possible to sort your execelfile in the other direction so that rows with all filled columns appear to the import wizard.WebfredNo, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Missing info on xls upload