|
Home > Archive > MS SQL Server DTS > July 2005 > ftp
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Jonathan Crawford 2005-07-24, 11:31 am |
| Hi
is there a way to dynamically set the name of the file to pick up
using the ftp control, say from a global variable?
thanks
jc
--
===============
Jonathan Crawford
01273 440018
07799 068570
fax 01273 380221
jc@tgsi.net
===============
| |
| Allan Mitchell 2005-07-24, 1:35 pm |
| yep
Have a look here in BOL
mk:@MSITStore:C:\Pro
gram%20Files\Microso
ft%20SQL%20Server\80
\Tools\Books\dtsprog
.chm::/dtsppropss_9nu1.htm
You could set this property through the Dynamic Properties task or you could
set it through code in an Active Script task.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Jonathan Crawford" <jc@jcrawford.co.uk> wrote in message
news:e3oDKuGkFHA.3608@TK2MSFTNGP12.phx.gbl...
> Hi
>
> is there a way to dynamically set the name of the file to pick up
> using the ftp control, say from a global variable?
>
> thanks
>
> jc
>
>
> --
>
> ===============
> Jonathan Crawford
> 01273 440018
> 07799 068570
> fax 01273 380221
> jc@tgsi.net
> ===============
>
>
| |
| Jonathan Crawford 2005-07-24, 8:29 pm |
| Hi
got it
great thanks
jonathan
"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:us7f$wHkFHA.4000@TK2MSFTNGP12.phx.gbl...
> yep
>
> Have a look here in BOL
>
>
mk:@MSITStore:C:\Pro
gram%20Files\Microso
ft%20SQL%20Server\80
\Tools\Books\dts
prog.chm::/dtsppropss_9nu1.htm
>
> You could set this property through the Dynamic Properties task or you
could
> set it through code in an Active Script task.
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "Jonathan Crawford" <jc@jcrawford.co.uk> wrote in message
> news:e3oDKuGkFHA.3608@TK2MSFTNGP12.phx.gbl...
>
>
|
|
|
|
|