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 |
|
jaypee_s
Starting Member
22 Posts |
 Posted - 2008-04-23 : 02:55:04
|
| While execuitng the package i got the following error, please help meCannot insert conversion between types DT_R8 and DT_STR is not supported. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-23 : 03:37:40
|
| It seems like you have data type mismatch between your source and destination. Can you give info on which step your are getting error? ALso it would be worthwhile if you could give an overview of your package structure. |
 |
|
|
jaypee_s
Starting Member
22 Posts |
Posted - 2008-04-23 : 04:31:57
|
| importing excel value into sql table. the excel column format is number and sql column datatype is varchar(50). to convert the data type i used data conversion object also...i guess it will be helpful... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-23 : 04:36:46
|
| Make the column to be in consistent with excel then |
|
|
|
jaypee_s
Starting Member
22 Posts |
Posted - 2008-04-23 : 04:51:14
|
| thanks visakh, just changned the excel format of the column to general, now it is working fine. |
|
|
|
|
|
|
SSIs