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 |
|
matnyc2000
Starting Member
16 Posts |
 Posted - 2007-10-09 : 16:02:08
|
| Hi,I have an xml datasource and an oledb destination. I want to insert data from an xml file into a sql server table. The xml source configurations are set properly (i.e., I have an xsd file and the data source identifies correctly the output column). The oledb destination properties seem set properly (it recognizes the input column and maps it the correct output column for the sql table). When I run the package there are no rows that get written to the table (with no errors either). help! I do have data in that xml file, dunno why it doesn't write any rows. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2007-10-09 : 16:51:03
|
| Before writing to destination, can you see any data at all? Use Data Viewer or preview your source to make sure you can see data. |
 |
|
|
|
|
|
data flow problem