Urgnt

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hemlata Shah (hemlata_shah_at_yahoo.com)
Date: 09/10/04 

Date: 10 Sep 2004 06:34:16 -0700

Hi All
   I am running out in a problem laid before me....
In of the modules of my web Application, I have the requirment of
sending email via DTS Consuming the data thru webservices rather
direct Stored Proc...
Steps:
1.Write A DTS SQL server job
2.Invoke a stored proc thru webservices ....
3.Get the data and send out an email to all the users got from the Web
srvices recordset...
I have not worked with DTS till date .
Can anyone let me know whether is this possible....
Any Help would be highly appreciated...

Regards
Hemlata Shah

Relevant Pages

  • Re: Urgnt
    ... You may want to store the recordset to a temp table and send out the email ... > sending email via DTS Consuming the data thru webservices rather ... > 2.Invoke a stored proc thru webservices ...
    (microsoft.public.sqlserver.dts)
  • Re: exporting to CSV
    ... entered as params and output for them a csv file. ... You can write a custom DTS package that is called from a stored proc. ... The stored proc will set global DTS variables based on these parameters and DTS will use these variables to filter out the unwanted records. ...
    (comp.databases.ms-sqlserver)
  • Re: DTS advice
    ... I was focusing on "not using DTS" to do the data transfer ... You are right - the stored proc is to be scheduled ... > next you say use DTS to do the scheduling ...
    (microsoft.public.sqlserver.dts)
  • Re: Insert Title into text file during transformation task in DTS
    ... Thank you very much for all your postings. ... My first row in a text file has ... I already tried to include in stored proc additional column ... DTS on scheduler automatically. ...
    (microsoft.public.sqlserver.dts)
  • Re: dts fails to execute
    ... So long as the metadata exposed by the stored proc is the same then ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... procedure which was used in the dts pkg I created earlier. ...
    (microsoft.public.sqlserver.dts)