Re: DTS Global Variables in Execute SQL tasks.
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 07/29/04
- Next message: Jeff Block: "Re: How to load data from large XML Files into SQL server 2000"
- Previous message: Darren Green: "Re: Name of a task in the package"
- In reply to: DHatheway: "Re: DTS Global Variables in Execute SQL tasks."
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Jul 2004 14:22:45 +0100
..and that is what the second link describes.
"DHatheway" <dlhatheway@mmm.com.nospam> wrote in message
news:%23r08ehNdEHA.1764@TK2MSFTNGP10.phx.gbl...
> There is another way: you can use an ActiveX script to modify the Execute
> SQL Task's SQLStatement property.
>
> "BarryC" <BarryC@discussions.microsoft.com> wrote in message
> news:CBE7BF02-6BCD-4EB0-B0EA-63D938A6FFBE@microsoft.com...
> > Thanks - Nevermind - check out http://www.sqldts.com/?234 and
> http://www.sqldts.com/?205 for a useful answer to the question.
> >
> > "BarryC" wrote:
> >
> > > Does anyone know of a way to pass DTS global variables into Execute
SQL
> Tasks?
> > >
> > > I am replacing some Send Mail tasks with a more generic TSQL proc that
> uses CDO.Message.1 to send to SMTP, and would like to make use of the
> existing mechanism that used DTS Global variables and a disconnected edit
to
> set the properties of the email. Another option would be to use an
ActiveX
> task to call the proc, but I'd rather not open another connection with ADO
> if I can avoid it......
> > >
> > > Thanks!
>
>
- Next message: Jeff Block: "Re: How to load data from large XML Files into SQL server 2000"
- Previous message: Darren Green: "Re: Name of a task in the package"
- In reply to: DHatheway: "Re: DTS Global Variables in Execute SQL tasks."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
