May 25, 2010 at 12:40 pm
Hi guys,
I have an xml shread and a sql database i need to create an ssis interface between these 2.i need to provide a 2 way communication between these two.
i m at first step,my question is that do i need to use xml source from dataflow and convert that in to OLE DB Destination and then i need to think about next mappings? orelse any other way to do this.what about the control flow then.plz help me with this
I APPRICIATE ALL SUGGETIONS
May 26, 2010 at 7:46 am
This was removed by the editor as SPAM
May 26, 2010 at 8:17 am
stewartc-708166 (5/26/2010)
In SSIS, data flow task, there is an XML data source that you could use for this.To update the XML file (or create a new file) you could use the XML destination
Where can I find the 'XML Destination'?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
May 26, 2010 at 8:35 am
Hi,
I am trying to use xml source and in connection manager window,its asking me for the .xsd file location.i dont exactly know what it means.if i select inline to disable .xsd connection string button it throwing me an error of multiple name spaces.
Thanks in advance
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply