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 |
|
Gayatri D.Patil
Yak Posting Veteran
58 Posts |
 Posted - 2008-03-05 : 01:47:07
|
| hii want to export data in excel to sql 2000.i right click on Data transformation servicesthen click on new pakage.then in desining i took one oledb provider for sql server.and as well as i took microsoft excel 97-2000.then i set the propeties and i took transform data task and set the properties.its execute successfully but when i check table in that table data is not inserted.so pls help megayatri |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-03-05 : 02:06:42
|
| Did u map the columns between Source and destination in the transform data task ? Also check the source file name and destination table name. |
 |
|
|
Gayatri D.Patil
Yak Posting Veteran
58 Posts |
Posted - 2008-03-05 : 02:39:15
|
| hiyes i maped the tables.and source file and destination file is correct.help megayatri |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-05 : 02:50:18
|
| If you preview the source, do you see any records?Make sure you have selected the correct workbook in your source. |
|
|
|
Gayatri D.Patil
Yak Posting Veteran
58 Posts |
Posted - 2008-03-05 : 05:48:47
|
| hiyes i saw the same records.i create other dts package that are run.and export data in sql.pls help megayatri |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
|
|
|
|
|
DTS