XML to SQL
Posted on 2004-08-24
I have installed soap 2.0 and sqlxmloledb 3.0 on sql 2k , win 2k server.
I have (i hope) properly setup IIS virtual directory to use these things.
Now when I am trying to do DTS or Import / Export and specify SQLXMLOLEDB or SQLXMLOLEDB 3.0 I see
"To connect click Properties"....I do ....then I am trying to enter Data Source and/or location of XML files but
anything I do it gives me error
error source : SQLXMLOLEDB 3.0
error desc : SQLOLEDB must be specified as a data provider.