locked
Problemas con Web Services task SSIS RRS feed

  • Pregunta

  • Yo tengo el siguiente error:

    Error: 0xC002F304 at Web Service Task, Web Service Task: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: There was an error generating the XML document..

    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)

    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)

    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

    Task failed: Web Service Task

    Los pasos que he hecho

    1.- Yo cree un stored procedure

    If Exists
    (Select * from sys.objects where name = 'usp_SelectRecords' and type = 'P')
    Drop Procedure
    usp_SelectRecords
    Go
    -- Create the stored procedure
    Create Procedure
    dbo].[usp_SelectRecords]
    As
    Begin
    SELECT LoadId, SubmittingApplication, TotalNumberofDoc, BusinessProcess
    ReferenceKey3_line_item FROM dbo.NSAI_XXX
    FOR XML AUTO, ELEMENTS
    End

    2.- Cree un End Point

    IF EXISTS ( SELECT NAME FROM sys.http_endpoints WHERE NAME = N'Records_EP' )
    DROP ENDPOINT Records_EP
    GO
    CREATE ENDPOINT [Records_EP]
     STATE=STARTED
     AS HTTP
     (
      PATH=N'/Connection'
      , PORTS = (CLEAR)
      ,AUTHENTICATION = (INTEGRATED)
      , SITE=N'localhost'
      , CLEAR_PORT = 8000
     )
     FOR SOAP
     (
      WEBMETHOD 'http://tempUri.org/'.'usp_SelectRecordsIGMS'
      ( NAME=N'[NSAI].[dbo].[usp_SelectRecordsIGMS]')
      , BATCHES=DISABLED
      , WSDL=DEFAULT
      , DATABASE=N'NSAI'
      , NAMESPACE=N'http://NSAI/Record'
     )
    GO

    3.- CReate en SSIS un web script taks

    General Connection :

     localhost:8000/connection?wsdl user and password

    WSDFile: empty file Invoice.wsdl

    OverWsdfile = true (overwrite)

    Input

    Service: RecordsIGMS_EP

    Method: spGenerateXML

    Ouput: FileConecction

    File :output file

    All this step following with MSD Microsoft I don't if I need create somelse

    Thanks so much for you help

    JAvier

    • Cambiado webJose domingo, 3 de febrero de 2013 2:38
    viernes, 18 de enero de 2013 17:54

Respuestas

Todas las respuestas