.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSIS Web Service Task error : SQL 2005

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
On my dev machine every thing works, When i put my SSIS on QA server for testing, I get following error . Customer has only SQL 2005. Please provide any input on how to resolve this issue. I provided HTTP URL as .asmx?WSDL    already in config file.   Code: 0xC002F304    Source: Log Start Message to Process Manager Web Service Web Service Task    Description: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The input Web Services Description Language (WSDL) file is not valid.    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil..ctor(Object connection, String downloadedWSDL)    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()". End Error DTExec: The package execution returned DTSER_FAILURE (1).Moonis Tahir MVP, MCPD, MCSD.net, MCTS BizTalk 2006/SQL 2005/SharePoint Server 2007 (Dev & Config)

View Complete Post

More Related Resource Links

Error during execution a web method for a web service task - SSIS 2005



I'm created a SSIS 2005 pkg that refers a wsdl file by a web service task. When I execute the task I can see an error as

"Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: cannot possible to find the method 'ProxyNamespace.CreateAndCompleteSubscriptionImplService.action'..    in Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)    in Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)    in Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()"

I haven't written the wsdl file, but I must use it to use the web service in SSIS environment.

Any suggests to me, please? Many thanks


I can add that the web service is implemented with Java technology and the same wsdl it is used with success inside a .NET application. Thanks

Could be a compatibility issue?

SSIS Web Service Task Error with WCF Service

I have read all the other posts on this site and have not been able to resolve my issue.For testing purposes i created a very simple WCF service that takes no arguments and returns true.  That is all it does.When i create a winform client and instantiate the service i can run my service method and get true back so i know the service works.I then create a test SSIS package with 1 task, a web service task.  I set the web service tasks properties as follows:http connection: http://localhost/WCF_SSIS_Prototype/Service1.svcwsdl file: C:\...\SSIS_WCF_Prototype\Service1.wsdl  (I know this is not a valid path, i changed it for posting to forum)Service: Service1Method: GetDataVariable: User::BResultWhen i run the package i get the following error:[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.Service1.GetData' not found..    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)    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()". I'm no

SSIS 2005-2008 web service task limits



I'm finding some articles or white papers about the limits or incompatibilities of SSIS 2005-2008 web service task.

Any suggests to me, please? Many thanks

Http connection and WSDLFile path for a web service task - SSIS 2005



I'm trying to create a SSIS 2005 pkg with a web service task. I need to create a Http connection, specifying an Url, and a WDSLFile Path. About these, two questions, please:

a) as URL for the Http connection, can I write f.e. http://mysite/mywebservices/mytestwebservice?wsdl=mytestwebservice.wsdl;

b) has the WDSLFile path to be a local path on my machine?

Many thanks for your suggests.

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3

Insert error description in sysjobhistory from ssis script task

hi. in ssis i have script task that, in some situations, raise error (Dts.TaskResult = ScriptResults.Failure). But in sysjobhistory table there is only shor description what happend (Description: The script returned a failure result.). Is there any way that i can set some system variable to describe what is error so that description ens up in sysjobhistory table? in the end, i want to look in job activity monitor and see that job is "red" and see the description that couses this failure.

Error Trapping in SSIS Script Task

Hi, I am processing a cube partition using an SSIS script task. The script works out the name of the partition which requires processing based on the system date.The problem I have is whenever there is a failure in the processing task the only error I get is that the script task returned a failure result. This is reported by the SQL job that calls the script task and also by SSIS package logging. I am running SQL2005 SP3How can I get my script to return a meningful error? Thanks in advance.

SSIS 2005 Control Flow Task Priority

The short version is I am looking for a way to prioritize certain tasks in SSIS 2005 control flows. That is I want to be able to set it up so that Task B does not start until Task A has started but Task B does not need to wait for Task A to complete. The goal is to reduce the amount of time where I have idle threads hanging around waiting for Task A to complete so that they can move onto Tasks C, D & E. The issue I am dealing with is converting a data warehouse load from a linear job that calls a bunch of SPs to an SSIS package calling the same SPs but running multiple threads in parallel. So basically I have a bunch of Execute SQL Task and Sequence Container objects with Precedent Constraints mapping out the dependencies. So far no problems, things are working and initial testing looks like it will cut our load time significantly. However I noticed that tasks with no downstream dependencies are commonly being sequenced before those that do have dependencies. This is causing a lot of idle time in certain spots that I would like to minimize. For example: I have about 60 procs involved with this load, ~10 of them have no dependencies at all and can run at any time. Then I have another one with no upstream dependencies but almost every other task in the job is dependent on it. I would like to make sure that the task with the dependencies is running before I pick up any of t

SSIS Execute Process Task Give "Access is Denied" error but it is not related to access control.

Hello All - I have a very weired SSIS problem. I am using BIDS in two machines - Windows 7 Professional Edition x64 bit (development workstation) and Windows 2003 Standard Edition x32 bit SP2 (server) . The visual studio version on both the machines are Version 2.0.50727 SP2. I found that my package's ExecuteProcessTask fails with "Access is denied" error in Windows2003 but runs ok in Windows 7 dev box. I then tried to debug the package in the Windows 2003 environment itself. The package failed in debug mode too with the same message. After looking for a while I found that when I shorten the Argument length of the failing ExecuteProcessTask the task did seem to work. So in Windows2003 environment if my argument exceeds 1846 characters the ExecuteProcessTask fails with message "Access is Denied". If the argument string is less than 1846 it works ok. In Windows 7 environment there is no problem at all. It does not seem like access problem but I may be wrong. Has anyone seen this? I will appreciate any reply. Thanks, Niben  

SSIS web service Task

Hello All, How  do you get around the same issue if your string type is based on a client token ?  I downloaded the .wsdl file, was able to see the service name, method and when selecting a method type, I am required to provide a client token which was given to me.  (Name column = clienttoken, Type = string, Value = 2227656 - ec8922 (client token numbers goes there)?  I am new to ssis and need your help please.  Note:  I downloaded another .wsdl file from a public site to test out the web service task and I was able to execute it without any errors.  I am using 2008 version.  Except for this .wsdl file which uses a parameter based security (client token) error message:  Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The web serrvice threw an error during method execution. The error is: An error occurred when verifying security fro the message..    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)   at Microsoft.SqlServer.Dts.Tasks.WebServiceT

Implementing Transaction in SSIS Package - [Execute SQL Task] Error: Failed to acquire connection "<

I have a simple SSIS package with three "Execute SQL Tasks". I am using ADO.Net Connection to execute SPs on a DB server. When I execute this package It works fine. So far so good. Now, I need to implement transation on this package. And problem starts now onwards. When I try to execute package after setting TransationOption = Required for the Sequence container which contains all the tasks, I get following error. [Execute SQL Task] Error: Failed to acquire connection "NYCDB0008.Export". Connection may not be configured correctly or you may not have the right permissions on this connection. "NYCDB0008.Export" is the name of the ADO.Net connection. I have been hunting for any solution but all in vain. I have tried changing all DTC settings on the dev as well as Database server. Please respond if anyone has any solution. Thanks! Anand

SSIS 2005: call WCF web service in ScriptTask (?)


Hi I am a bit of SSIS and WCF newbie...I am working on a SSIS 2005 project and other company writes web service for me to consume.  I use "script task" in SSIS and copy the WSDL-generated proxy file to consume web service..it has been working ok but yesterday I got a new proxy class file from the other company with heading like this:


<System.Diagnostics.DebuggerStepThroughAttribute(), _

     System.CodeDom.Compiler.GeneratedCodeAttribute("System.Runtime.Serialization", ""), _

     System.Runtime.Serialization.DataContractAttribute(Name:="GetBondTenancy", [Namespace]:="http://xxx.x.xxx.notshown.xxx/")> _

    Partial Public Class GetBondTenancy

        Inherits Object

        Implements System.Runtime.Serialization.IExtensibleDataObject

SSIS complains about not recognizing 'DataContractAttribute' and 'IExtensibleDataObject' but sure it is not just a matter of DLL referencing... is there a way I can consume this Web service?

p.s. Please let me know if you guys require more info....

The SQL Server(2005 express) service failed to start. Error 29503


Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is  (1067) The process terminated unexpectedly.

Initially the SQL Server was running over there, later one day it stopped. When trying to start manually I got "The process terminated unexpectedly" error. Tthen I uninstalled it and tried to install again, but got "Error 29503. The SQL Server service failed to start" error while installation and installation rolled back. If I install it using Local System and without "Enable User Instance" I get same error but after multiple retry it started. However my desktop application is not running and giving error message "Failed to generate a user instance of SQL Server due to a failure process for the user instance. The connection will be closed".

I tried "sp_Configure .......... " and "Reconfigure" to enable user instance but still got "Failed to generate......" error.

Another problem is that SQL Server service starts in multiple retry.

I have tried most of the forum solutions however I am still getting the same error in my desktop application. Mos

How to generate an excel and send it as email attachment in SSIS 2005 Script Task Component?


I am using a "Script Task" component. I am trying with following three simple steps:

1) Obtain the excel content in HTML

Dim reportInHtml As String = GenerateHTMLReport()

2) Generate an excel with below code:

Dim message As MailMessage

message = New MailMessage(fromAddress, toAddress, subject, String.Empty)

Using memoryStream As MemoryStream = New MemoryStream()

        Dim contentAsBytes As Byte() = Encoding.UTF8.GetBytes(reportInHtml)
        memoryStream.Write(contentAsBytes, 0, contentAsBytes.Length)
        memoryStream.Seek(0, SeekOrigin.Begin)

        Dim contentType As ContentType = New ContentType()
        contentType.MediaType = "application/ms-excel"
        contentType.Name = "Excel_Report.xls"

        Dim excelAttachment

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) windows update install error 0xD

I have tried several times to use Windows Update to install the SQL Server 2005 Express Edition Service Pack 3 (KB955706) but it keeps failing.  When I check the install history all I get is error code 0xD59

I have Windows XP SP2 on a Core 2 Duo Dell Vostro 1500

Does SSIS Web Service Task work with WCF?


From what I am reading, SSIS Web Service Task does not work with WCF, even though SSIS is 5 years old and WCF is 3. Did they fix it in 2008? R2? Will they ever?

And if it doesn't work, can someone give me pointers on setting up a Script Component to feed some variables to the WCF as inputs?

Thanks in advance.

Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

SSIS Error in Script task: "Conversion from string "C002" to type 'Integer' is not valid"


Hi All,

I have a script component in my Dataflow that generates Error Description string.

But I am not trying to convert anything in my Script as you can see below.

Here is the Code inside the SCR_component.


Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class ScriptMain
    Inherits UserComponent
    Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
     'Use the incoming error number as a parameter to GetErrorDescription
    Row.ErrorDescription = ComponentMetaData.GetErrorDescription(Row.ErrorCode)
   End Sub
End Class


When I run the package , it fails at this script task with the following error:

Description: System.InvalidCastException: Conversion from string "C002" to type 'Integer' is not valid.


The value "C002" is actually a column in the metadata and its type is "DT_STR". I am not trying to convert it in my Script as you can see

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend