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 ? :confused:
Or
Can i call the Web Service in the DTS Package using the VB.Script ?:confused:

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

Thankssince 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...|||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.|||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)

DTS mapping global variable to column

Hi
I have doubt in DTS -i want 2 export text file into Database - which i can able to do it while running DTS it will prompt inputbox to enter the datetime of transferring which i should update in the datetime column of the table,which i will store this user input value in globalvariables- so how should i map to column.
i placed text object (source) and connection object and active x script object

thanks in advance
HrMay search SQL DTS (http://www.sqldts.com) website.