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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

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

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server
 

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", "3.0.0.0"), _

     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?

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




View Complete Post


More Related Resource Links

How to call SSIS Package through web service based on ASp.NET using C#

  
Hi All, How to call SSIS Package through web service based on ASp.NET using C#.   Regards Amit

SSIS Web Service Task error : SQL 2005

  
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)

SSIS 2005-2008 web service task limits

  

Hi.

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


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

  

Hi.

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?


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

  

Hi.

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.


How to Call .Exe in Shared Folder using Script Task Component in SSIS 2005 ?

  

Hi friends,

I have a Shared Folder where Two .NET .Exes are placed.

My requirment is to call this two Exes using Script Task Component.

I am very bigginer in SSIS.

Please provide me Assistance to solve this issue.

if you need more information regarding problem, let me know.

 


Call MOM: Instrument and Monitor Your ASP.NET Apps Using WMI and MOM 2005

  

The current version of Windows Management Instrumentation (WMI) satisfies many current and future manageability requirements. In this article Michael Jurek demonstrates how WMI provides important system management capabilities and develops a WMI-aware monitoring solution you can use to instrument your ASP.NET applications. He then introduces the capabilities of MOM 2005 that allow you to monitor these instrumented applications.

Michael Jurek

MSDN Magazine September 2005


Invalid web service call, missing value for parameter: \u0027prefixo\u0027 (AutoCompleteExtender)

  

Good afternoon.

I'm trying to put an AutoCompleteExtender working, but i'm having an error, that i discovered with Fiddler, that is the reason that the autocomplete doesn't work:

> **{"Message":"Invalid web service call,
> missing value for parameter:
> \u0027prefixo\u0027."**,"StackTrace":"
> at
> System.Web.Script.Services.WebServiceMethodData.CallMethod(Object
> target, IDictionary`2 parameters)\r\n
> at
> System.Web.Script.Services.WebServiceMethodData.CallMethodFromRawParams(Object
> target, IDictionary`2 parameters)\r\n
> at
> System.Web.Script.Services.RestHandler.InvokeMethod(HttpContext
> context, WebServiceMethodData
> methodData, IDictionary`2
> rawParams)\r\n at
> System.Web.Script.Services.RestHandler.ExecuteWebServiceCall(HttpContext
> context, WebServiceMethodData
> methodData)","ExceptionType":"System.InvalidOperationException"}

This is the webservice code:

    Imports System.Web.Services
    Imports System.Web.Services.Protocols
    Imports System.ComponentModel
    Imports GcpBE750
    Imports ErpBS750
    Imports StdBE750
    
    ' To allow this Web Service to be called fro

SQL Server 2005 - Installation in Cluster Environment - "Service SQL Server Browser (SQLBrowser) fai

  
Windows Server 2003 R2 Enterprise Edition SP2 32-bit All updates and patches installed Two-node cluster environment configured. Cluster functions perfectly. Trying to install SQL Server 2005 Enterprise Edition (32-bit) as a clustered application. Installation proceeds fine until it begins to install the SQL Server Database Services product. Status window says "Starting Services. Service: SQL Server Browser". Error message is presented: "Service 'SQL Server Browser' (SQLBrowser) failed to start. Verify that you have sufficient privileges to start system services". SQL Server Service Account is in the Administrators group on both local systems, and is a domain account. Account used for the installation is in the Administrators group on both local systems, and is a domain account. Have cancelled out of the install and rebooted both servers numerous times. Exact same error continues to occur. Cluster is active and all resources are owned by node #1 - the node where SQL Server Installation is being run. In the event viewer, I see: Event ID: 10 Description: The SQLBrowser service was unable to establish SQL instance and connectivity discovery". I am also seeing errors like: Source: SQLBrowser. The SQL configuration for SQL is inaccessible or invalid. Source: SQLBrowser. The Configuration of the AdminConnection\TCP protocol in the SQL instance xxxxxx i

SQL Server 2005 Express Edition Service Pack 3 (KB955706) update is successful but repeats installin

  
  Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) (update 1 of 1) This update seems to be stuck in a loop of installing, each time it successfull installs acccording to automatic updates. Then says it requires installing again straight away. This has been happening for 10 days now. I have tried a manual update from the website rather than automatic updates, no change. Any ideas why? Have posted in Windows update which is where I think the problem lies but they have suggested I post here also.

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) - will not download.install on W

  
I have tried and tried unsuccessfully to get this download to install properly. I get no error message at all but it quite clearly is not working properly. This has all ready taken me hours and hours of my time with no success (after following the fixes mentioned on this site). I look forward to suggestions at to how to proceed that may actually work. Many thanks cdbc81

Which SQL Server 2005 Express Edition Service Pack to Install?

  
I have Windows 2008 Small Business Server Standard Edition.  When I scan for updates I get two different SQL service packs showing up, with the same KB955706 number.  I'm wondering which I should install, or if both, what order to install them in?  The first one is labeled: Microsoft SQL Server 2005 Express Edition Service Pack 3 The second one is labeled: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3 For applications, I have Blackbaud The Financial Edge v7.78 (accounting package for clubs) installed that uses SQL Server 2005 Express Edition for its database engine.  The new upgrade for this software requires SP3 which is why I need to know which service pack to install.  Also, please let me know if there are any tricks to getting the service packs installed on 2008 SBS Standard Edition.  I know sometimes registry settings need to be changed for SQL service packs to be installed properly. Thank you for your help.  

Trying to call an asmx web service from a test project

  
I am trying to create a proxy for an asmx web service. The only thing I find in Visual Studio 2008 is a service reference. How do I call an asmx web service with a service reference? Certified Geek. Professional Data dude.

SQL Reporting Service 2005 - share schedule report performace T-SQL query?

  
Hi, I have SQL 2005 reporting services Shared Schedules and each schedule has its own subscribed report. I would like to have T-SQL 2005 to find out performance loading on each schedule. i.e. MySchedule_1 has 10 reports in it and AVEGARE report eaxecutiontime is like 3mins 5sec      MySchedule_2 has 7 reports in it and AVEGARE report eaxecutiontime is like 4mins 9sec Pls can I have T-SQL 2005 on ReportServer database to find out load on each schedules (and more drill-down to each report level for execution time)?

Unable to call an asmx web service using windows authentication from a Service workflow

  
Hello, I need to use an existing asmx service from inside my service workflow and I am unable to call it. This asmx service is hosted in a web application with iis set to windows authentication, anonymous is not allowed. I need to send the authentication, only way seems too be using transport for basicHttpBindings. Every time I try to call the service I get an error saying that there is nothing listening to the url of the service generated automatically by VS when I added the Service Reference ? my web config <configuration> <configSections> </configSections> <system.web> <compilation debug="true" targetFramework="4.0" /> </system.web> <system.serviceModel> <protocolMapping> <add scheme="http" binding="wsHttpBinding" bindingConfiguration="WindowsCreds" /> </protocolMapping> <bindings> <basicHttpBinding> <binding name="UtilitiesSoap" closeTimeout="00:01:00" openTimeout="00:01:00" receiveTimeout="00:10:00" sendTimeout="00:01:00" allowCookies="false" bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard" maxBufferSize="65536" maxBufferPoolSize="524288" maxReceivedMessageSize="65536"

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel
Categories: 
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