DTS programming

Hi,

I am writing program (in VFP 8) to upsize data from VFP to SQL 2K. For some,
I create text files and use BCP but for tables with memo fields VFP does not
output memo to text file.

Since the data is large and process needs to be automated I need to know how
to program using DTS i.e. DTS program runs to copy a VFP table to a specific
SQL table with column mapping. This process will be repeated on several
tables.

Any help is welcome.

TIA

Kamran

Lucas
Tue Sep 21 12:21:03 CDT 2004

"Kamran" <k-a-q@bigmailbox.net> wrote in
news:OoFB3y$nEHA.3396@tk2msftngp13.phx.gbl:

> Since the data is large and process needs to be automated I need to
> know how to program using DTS i.e. DTS program runs to copy a VFP
> table to a specific SQL table with column mapping. This process will
> be repeated on several tables.

Check out http://www.sqldts.com

--
Lucas Tam (REMOVEnntp@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

David
Tue Sep 21 15:33:03 CDT 2004

A fast way to get started on DTS is to use the Import / Export Wizard to
build a package interactively for you, then open up the package in DTS
Designer and examine and modify it from there. DTS Designer will also let
you save the package as Visual Basic code if you need to manipulate and run
packages programmatically.

--
David Portas
SQL Server MVP
--