Re: script for ftp

Thanks! Got it!
"narayaana" <ugo.peltier@xxxxxxx> wrote in message
news:uVGYkpEbHHA.4140@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx> wrote in message
news:uJDyWLAbHHA.5080@xxxxxxxxxxxxxxxxxxxxxxx
Sorry, I forgot to tell you that this is 2000.

"narayaana" <ugo.peltier@xxxxxxx> wrote in message
news:%23ppu$i8aHHA.3960@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx> wrote in message
news:OFTwdO8aHHA.2064@xxxxxxxxxxxxxxxxxxxxxxx
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.








.

Relevant Pages

  • Re: [SPARK] Code safety and information hiding
    ... the documentation:). ... This can be achieved by the environment task executing the initialization code for the package during elaboration, or by an initialization task in the package body. ... design was better than the global variable it replaces. ... The customers of the SW designed around large numbers of undocumented global variables seemed satisfied with it. ...
    (comp.lang.ada)
  • Re: Execute Package Task and setting its inner Package Global Vaiables
    ... Ok So you want to retrieve the values of child package Global Variables and use them in you Parent as well as setting child global ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server 2000 - Parameters in a Transform Data Task
    ... I know how to pass parameters to a DTS package with DTSRUN. ... I supplied values for all the global variables in the package ... Transform Data Task is not picking up the parameter for the SQL Select ... parameters on the DTSRUN command line and it picks those up properly. ...
    (microsoft.public.sqlserver.dts)
  • Re: script for ftp
    ... Packages Global variables can be set in Package> Properties> Global ... you can then use a dynamic property task object to dynamically affect these ... SSIS service, write click on package, run ... ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute Package Task and setting its inner Package Global Vaiables
    ... If you are using the ExecutePackage task then you can pass through a Parent package Global Variable to the child. ... Global variables values from the child package back in the parent. ...
    (microsoft.public.sqlserver.dts)
Quantcast