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 |
|
govindts
Starting Member
33 Posts |
 Posted - 2008-03-24 : 13:15:46
|
| All, I am trying to load excel data into sqlserver through SSIS.I have only one field in excel which has 6 rows as below.The first row(<1) is loading into sqlserver as null value. Sqlserver destination table field is VARCHAR(10). Please help me on resolving this issue.<112345 |
|
|
govindts
Starting Member
33 Posts |
Posted - 2008-03-24 : 15:50:50
|
| This issue is resolved by adding couple of parameters(IMEX=1;MAXROWSTOSCAN=0) in excel connection manager. Thanks |
 |
|
|
|
|
|
Loading null value from excel