|
|
You're in the
sql server dts
group:script for ftp
sql server dts:
into a sp. Not sure how to go about this. Here's the batch file: ftp -i -s:c:\laufer.txt laufer.com > c:\laufer.log It uses this laufer.txt The laufer.txt is: <User Name> <Password> ascii lcd c:\temp cd /EDIOUT/TRANPRO Mget * quit I tried using the ftp task and can get connected but I nned to change directory and the download a file and save that file to a specific directory (c:\temp) in this sample. Any help would be appreciated. Thanks.
2 ways to do so:
1- your package is small, when you run the package (I suggest you connect to SSIS service, write click on package (import it if necessary), run ... you are invited to change connection strings (to files, variables etc.) in section "Connection Manager" a command line is generated, you can copy it! modify from this model! 2- use SSIS > Package Configuration in Visual Studio management, you can then save the value in an xml config file, an environment var etc (just once you are in SSIS > Package Configuration management, press on help ;)) [quoted text, click to view] "SAC" <sac@somewhere.com> wrote in message news:OFTwdO8aHHA.2064@TK2MSFTNGP05.phx.gbl... >I made a batch file which runs an ftp script. I'd like to put this either >into a sp. Not sure how to go about this. > > Here's the batch file: > > ftp -i -s:c:\laufer.txt laufer.com > c:\laufer.log > > It uses this laufer.txt > > The laufer.txt is: > > <User Name> > <Password> > ascii > lcd c:\temp > cd /EDIOUT/TRANPRO > Mget * > quit > > I tried using the ftp task and can get connected but I nned to change > directory and the download a file and save that file to a specific > directory (c:\temp) in this sample. > > Any help would be appreciated. > > Thanks.
Sorry, I forgot to tell you that this is 2000.
[quoted text, click to view] "narayaana" <ugo.peltier@free.fr> wrote in message news:%23ppu$i8aHHA.3960@TK2MSFTNGP04.phx.gbl... >2 ways to do so: > 1- > your package is small, when you run the package (I suggest you connect to > SSIS service, write click on package (import it if necessary), run ... > you are invited to change connection strings (to files, variables etc.) in > section "Connection Manager" > a command line is generated, you can copy it! > modify from this model! > > 2- > use SSIS > Package Configuration in Visual Studio management, > you can then save the value in an xml config file, an environment var etc > (just once you are in SSIS > Package Configuration management, press on > help ;)) > > "SAC" <sac@somewhere.com> wrote in message > news:OFTwdO8aHHA.2064@TK2MSFTNGP05.phx.gbl... >>I made a batch file which runs an ftp script. I'd like to put this either >>into a sp. Not sure how to go about this. >> >> Here's the batch file: >> >> ftp -i -s:c:\laufer.txt laufer.com > c:\laufer.log >> >> It uses this laufer.txt >> >> The laufer.txt is: >> >> <User Name> >> <Password> >> ascii >> lcd c:\temp >> cd /EDIOUT/TRANPRO >> Mget * >> quit >> >> I tried using the ftp task and can get connected but I nned to change >> directory and the download a file and save that file to a specific >> directory (c:\temp) in this sample. >> >> Any help would be appreciated. >> >> Thanks. > >
Quite not the same and regarding SSIS current handling I would say a bit
easier in you case, At run time you can re-specify Global Variables values in dtsrun command line Packages Global variables can be set in Package > Properties > Global Variables Tab. not in detail but grossly, for a Global Variable of type string: add to dtsrun: /A VarName:8=Value (8 stands for string type, see help > dtsrun utility) you can then use a dynamic property task object to dynamically affect these Global Variables to other task in the dts and in particular to ftp transfer task. Note: dynamic properties task can use other sources than Global Variables such as ini file, sql query, environement vars etc.. I usually have to use per database specific parameter values, which is why I would tend to use Sql Query in SQL2000 times... [quoted text, click to view] "SAC" <sac@somewhere.com> wrote in message news:uJDyWLAbHHA.5080@TK2MSFTNGP02.phx.gbl... > Sorry, I forgot to tell you that this is 2000. > > "narayaana" <ugo.peltier@free.fr> wrote in message > news:%23ppu$i8aHHA.3960@TK2MSFTNGP04.phx.gbl... >>2 ways to do so: >> 1- >> your package is small, when you run the package (I suggest you connect to >> SSIS service, write click on package (import it if necessary), run ... >> you are invited to change connection strings (to files, variables etc.) >> in section "Connection Manager" >> a command line is generated, you can copy it! >> modify from this model! >> >> 2- >> use SSIS > Package Configuration in Visual Studio management, >> you can then save the value in an xml config file, an environment var etc >> (just once you are in SSIS > Package Configuration management, press on >> help ;)) >> >> "SAC" <sac@somewhere.com> wrote in message >> news:OFTwdO8aHHA.2064@TK2MSFTNGP05.phx.gbl... >>>I made a batch file which runs an ftp script. I'd like to put this >>>either into a sp. Not sure how to go about this. >>> >>> Here's the batch file: >>> >>> ftp -i -s:c:\laufer.txt laufer.com > c:\laufer.log >>> >>> It uses this laufer.txt >>> >>> The laufer.txt is: >>> >>> <User Name> >>> <Password> >>> ascii >>> lcd c:\temp >>> cd /EDIOUT/TRANPRO >>> Mget * >>> quit >>> >>> I tried using the ftp task and can get connected but I nned to change >>> directory and the download a file and save that file to a specific >>> directory (c:\temp) in this sample. >>> >>> Any help would be appreciated. >>> >>> Thanks. >> >> > >
Thanks! Got it!
[quoted text, click to view] "narayaana" <ugo.peltier@free.fr> wrote in message news:uVGYkpEbHHA.4140@TK2MSFTNGP06.phx.gbl... > Quite not the same and regarding SSIS current handling I would say a bit > easier in you case, > > At run time you can re-specify Global Variables values in dtsrun command > line > Packages Global variables can be set in Package > Properties > Global > Variables Tab. > not in detail but grossly, for a Global Variable of type string: add to > dtsrun: /A VarName:8=Value (8 stands for string type, see help > dtsrun > utility) > > you can then use a dynamic property task object to dynamically affect > these Global Variables to other task in the dts and in particular to ftp > transfer task. > Note: dynamic properties task can use other sources than Global Variables > such as ini file, sql query, environement vars etc.. > I usually have to use per database specific parameter values, which is why > I would tend to use Sql Query in SQL2000 times... > > > "SAC" <sac@somewhere.com> wrote in message > news:uJDyWLAbHHA.5080@TK2MSFTNGP02.phx.gbl... >> Sorry, I forgot to tell you that this is 2000. >> >> "narayaana" <ugo.peltier@free.fr> wrote in message >> news:%23ppu$i8aHHA.3960@TK2MSFTNGP04.phx.gbl... >>>2 ways to do so: >>> 1- >>> your package is small, when you run the package (I suggest you connect >>> to SSIS service, write click on package (import it if necessary), run >>> ... >>> you are invited to change connection strings (to files, variables etc.) >>> in section "Connection Manager" >>> a command line is generated, you can copy it! >>> modify from this model! >>> >>> 2- >>> use SSIS > Package Configuration in Visual Studio management, >>> you can then save the value in an xml config file, an environment var >>> etc (just once you are in SSIS > Package Configuration management, press >>> on help ;)) >>> >>> "SAC" <sac@somewhere.com> wrote in message >>> news:OFTwdO8aHHA.2064@TK2MSFTNGP05.phx.gbl... >>>>I made a batch file which runs an ftp script. I'd like to put this >>>>either into a sp. Not sure how to go about this. >>>> >>>> Here's the batch file: >>>> >>>> ftp -i -s:c:\laufer.txt laufer.com > c:\laufer.log >>>> >>>> It uses this laufer.txt >>>> >>>> The laufer.txt is: >>>> >>>> <User Name> >>>> <Password> >>>> ascii >>>> lcd c:\temp >>>> cd /EDIOUT/TRANPRO >>>> Mget * >>>> quit >>>> >>>> I tried using the ftp task and can get connected but I nned to change >>>> directory and the download a file and save that file to a specific >>>> directory (c:\temp) in this sample. >>>> >>>> Any help would be appreciated. >>>> >>>> Thanks. >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |