I was wondering if anyone has had any experience with creating a MS SQL SSIS (SQL Server Integration Services) package with AXL.

The following error is received when using AXLAPI.wsdl: 
MS SQL Says: Could not read the Web Services Description Language (WSDL) file. The input WSDL file is
not valid. The following error occurred while reading the file. There is an error in XML
document (1063, 11)..

Is there a AXLAPI.wsdl that would work with a MS SQL SSIS package?

Ahmed, generally it is not allowed to access CUCM database directly and even if allowed it is not a good practice to access it directly. You are correct, AXL is the best way to achieve that.

If you explain more what data you are looking for maybe we can help you more.



BR

WA



From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
Sent: Tuesday, January 24, 2012 12:33 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Abdul Basit Sheikh in Administration XML (AXL) - Administration XML Questions: RE: Integrating AXL with SSIS



Abdul Basit Sheikh has created a new message in the forum "Administration XML Questions":

--------------------------------------------------------------

I was wondering if anyone has had any experience with creating a MS SQL SSIS (SQL Server Integration Services) package with AXL.

The following error is received when using AXLAPI.wsdl:
MS SQL Says: Could not read the Web Services Description Language (WSDL) file. The input WSDL file is
not valid. The following error occurred while reading the file. There is an error in XML
document (1063, 11)..

Is there a AXLAPI.wsdl that would work with a MS SQL SSIS package?



Same issue with me, I'm trying to connect to CUCM database most preferably using ODBC. But going through different rescources I found that AXL is the only option avaiable. Can somebody please reply to this post.
--
To respond to this post, please click the following link:

<http://developer.cisco.com/web/axl/forums/-/message_boards/view_message/5050159>

or simply reply to this email.

Hi,

SSIS has a tool named "Web Service Task" for use webservices but when I tried use with "executeSQLQuery" parameter I had problems because is a complex type param. Finally, I must use another SSIS tool named "Script Task".

This link could be useful for you, http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/01/28/consuming-web-services-in-ssis-script-task.aspx

Best regards,
Luis.