Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kokkik

    DTS non stop pumping data into .csv file !

    Enviroment: OS: Windows 2003 DB: SQL 2000 Overvew: DTS using ODBC to Sybase for capturing data from 13 separate tables and dump them into 13 different .csv files. Each task run concurrently. Total output of these 13 files are around 300Mb. A final task will compress the files into a 30Mb zip...
  2. kokkik

    Pull data from an Advantage Database

    You need to 1. have advantage client installed 2. Configure client interface driver pointing to advantage db. 3. Configure a ODBC DSN for it 4. Use DTS and stating the source from the DSN
  3. kokkik

    VBS or DTS

    i think i've misguided earlier, DTS itself has no FTP feature. But it can incorporate either other component such as batch file, vbscript, etc to perform the task.
  4. kokkik

    VBS or DTS

    DTS and VBS could perform FTP (export or import). I would prefer DTS if the system does require to capture data from DB to send data to DB in a large amount. I would use VBS if web user need to send in data thru your web application. After all, it's about balancing your load between your DB and...

Part and Inventory Search

Back
Top