var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: xml import in Sql server
I am an Italian planner. There I write using a translator software, for which I hope be clear. my problem is the following:
I must repeat data from an Access database in a Sql Server.
I make it using VB with ADO.
I open the Access [recordset] with ADO and the except with the SAVE method in a XML file.
For read it I don't have problems. I do an OPEN with an ADO object.
But wants him behavior with a DTS or with a [stored] procedures don't know like operate.
The [stored] procedures of system [sp_xml_preparedocument] works only with variables and not with files.
How behavior then?
u cannot give file as input , u can open the XML in the Program and pass it as text or ntext to the stored procedure