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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 XML Load

Author  Topic 

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2008-04-29 : 10:24:17
I am new to SSIS and am looking to load XML files (with a XSD validations) into tables via a SSIS package.
I have created a XML source and OLE db Destination to load and map the XML to table in my Sqlserver DB.
But have no idea how to link the source XML to OLE DB destination.
I have created a connection manager what provider do i need to select from list since i found sqlxml oledb,sqlxmloledb4.0.
When selected it showing error..
I need a input column
Please help..
   

- Advertisement -