Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2007
    Posts
    1

    Unanswered: DTS package in 2005

    Hi All ,
    I have a DTS package in SQL Server 2005 , I will have to use the web service in the DTS Package, So my Biggest Doubt is

    Can i Call the Web Service in the DTS Package using the Stored Procedure ?
    Or
    Can i call the Web Service in the DTS Package using the VB.Script ?

    This is the Most Important thing for Us Right of now, and Will be happy if i could get some help.


    Thanks

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    since you are using 2005, you can call a web service in a sproc if it's a CLR sproc. a CLR sproc is implemented in managed code and can do anything you could do in C#, including calling a web service. It doesn't mean you *should* do it though...

  3. #3
    Join Date
    Sep 2002
    Posts
    53

    Integration Services

    If you are using Sql Server 2005 then I hope that you mean Integration Services and you can easily call a Web Service from there. It is a Control Flow task specifically named Web Service Task. There are several examples of how to use the task floating around the net and a couple on Microsoft's site.
    KDK

  4. #4
    Join Date
    Jul 2002
    Posts
    229
    Many people import their DTS packages (to the place under Management > Legacy) and continue using them.
    (Honestly, much quicker than trying to understand the SSIS design tool IMO)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •