G'day all,
I'm new to DTS and just need a pointer in the right direction. I want to
set-up a package that will extract data records from a remote database,
write the data to a comma separated text file, then ftp the file to my Linux
server. I've set-up an Execute SQL task with the SQL statement to extract
the data into a global variable (what should the data type be for this
variable?) but don't know how to get the data into a file. I've worked out
that I'll need to write a script to do the FTP as the DTS FTP task doesn't
allow me to specify a destination other than a local or network drive (which
seems a pretty strange limitation).

I've got a book on DTS but it's pretty slow going. Any help will be greatly
appreciated.

cheers
peterDavey
Melbourne

OK

1. Why are you reading into a Global Variable ? Why can you not just write
to a text file in a datapump task ? or even use BCP ?
2. The DTS FTP task is pull only not push. Can you use FTP.exe to do the
FTP part.



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"peterDavey" <peter.davey (AT) austin (DOT) org.au> wrote

Allan,
These are good questions. The answer is I don't have a clue (yet) as I'm new
to DTS and there's a lot to learn. I was just just looking for a bit of
start and your suggestion to use the DataPump is it. I was a bit confused
by the Transform Data Task because it's looking for a destination connection
as well as a source. I've gone back to the book and think I'll be able tol
work it out. I was planning on using ftp.exe to move the file.

Thanks for your help.

cheers
peterDavey

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hi

Anyone who is new to DTS should spend some time browsing Allan and Darren's
site
www.SQLDTS.com, there is just about everything you will ever need to know
there.

John
"peterDavey" <peter.davey (AT) austin (DOT) org.au> wrote