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 |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-05-21 : 00:59:14
|
Hi, I need to import an excel data to sql table (excel 2003 and sql2005).I created a project in SSIS with appropriate components. Since my data in Excel is in DT_R8 and DT_WSTR format and my SQL data is in DT_I4 and DT_STR format I put a Data Conversion component to convert the data types. It runs without error and doesn't import anything to table!!  Any idea is appreciated |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-21 : 01:24:00
|
| What are components used? Are dumping it to destination directly from derived column?Have you previewed the data from source? ALso it would be worth putting a data viewer just before destination population step ( I think you're using OLEDB destination or SQL Destination) to check whether records are returned. |
 |
|
|
|
|
|
Data Conversion While Importing