Hello All & Greetings.

I am looking for any suggestions / examples for the following.

I want to creat a DTS PAckage to do the following:

1. Per Schedule, run a SQL query - periodically.
2. Export the result set to a Text File.
3. Schedule the above TextFile to be FTP'd to another destination.

I am looking for any suggestions / How-TOs / examples, etc and would
apprecaite any help in this matter incl. actual steps, links, ref material,
etc.

Thanks in advance to all.

RK

Have a look on SQLDTS.com it has examples of everything you require.

--
HTH
Ryan Waight, MCDBA, MCSE

"RK" <kishanb (AT) cansciences (DOT) com> wrote

Hi Ryan:

Thanks for yur reply.

Before posting my original message, I did visit the site you mentioned
about. At least I did not find anything for the FTP stuff. Can I reqyest you
to send me a link to a specific item you had in mind from the site, if you
will, please.

Thanks and appreciaet very much your response,

RK

"Ryan Waight" <Ryan_Waight (AT) nospam (DOT) hotmail.com> wrote

Sorry, don't know where exactly.

I use FTP within some DTS packages.

I use the 'Execute Process Task' to invoke a Batch .BAT file, the BAT file
contains the FTP commands.

--
HTH
Ryan Waight, MCDBA, MCSE

"RK" <kishanb (AT) cansciences (DOT) com> wrote