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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-01-21 : 07:47:27
|
| Dear All,I need to import the data from Excel to data base table.In the excel sheet one column is having data type Alphanumric (ex:A7666,and 76666 etc ).I declared database table column data type as varchar(10) and trying to import by SSIS But the value with 76666 is not loaded to destination table but package says 2 rows are transfered to destination.Please help in this regard.Thanks,Gangadhar |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-01-21 : 08:25:02
|
| I found the solution here,,Thanks,Gangadhar |
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
|
|
|
|
|
Data importing to table from Excel file