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 |
|
jamie_pattison
Yak Posting Veteran
65 Posts |
 Posted - 2008-08-20 : 11:12:58
|
| I tried to convert a csv file to xls usiing Import and Export Wizard to see how it works before i try it in SSIS.I get around the last step and receive the error:"Column information for the source and the destination data could not be retrieved, or the data types of source columns were not mapped correctly to those available on the destination provider."Im using a Flat File as the source and Excel as the destination - Could anyone advise where the issue maybe as i can view the data with headers in the preview pane?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-20 : 12:40:49
|
| as it suggests did you have a look at mappings to see if all columns are correctly mapped? |
 |
|
|
jamie_pattison
Yak Posting Veteran
65 Posts |
Posted - 2008-08-21 : 07:21:50
|
| Yes that was the first thing i did. Im now removing each column at a time to see if there is a problem with the data or something similar..... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-21 : 07:29:55
|
quote:
Originally posted by jamie_pattison
Yes that was the first thing i did. Im now removing each column at a time to see if there is a problem with the data or something similar.....
is there some mismatches with datatypes between source & destination spotted? |
|
|
|
|
|
|
Error during conversion