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 |
|
rwlopez
Yak Posting Veteran
80 Posts |
 Posted - 2007-04-03 : 18:56:23
|
| I am trying to import XML data using SSIS. The schema I was given does not seem to work at all. However if I generate a schema in the xml source editor it seems to work although I am having problems with it. When the schema is generated it is assigning fields where there is only numeric data the type unsignedInt. The original schema actually used string for this field. The problem is that I cannot import the unsignedInt data type into a SQL table because it seems that no data type is compatible with unsignedInt. If I change the data type in the schema file to string the changes don't seem to appear in SSIS. For example in the data flow path the data type in the metadata still says DT_UI4. Does anyone have any experience with this? |
|
|
|
|
|
XML Schema Problems