Results 1 to 4 of 4

Thread: DTS - mapping?

  1. #1
    Join Date
    Jun 2005
    Location
    Waukesha WI
    Posts
    78

    Unanswered: DTS - mapping?

    I do a lot of converting of files. Typically taking a delimited txt or csv file and creating a temp table. Then converting the temp table into a standard table.

    What tools are available (and good) to help do this - it really gets to be a pain after a while?

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    I'm not sure what you're looking for but have you checked out external tables?

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Or, you might try SQL*Loader utility and compare it to external tables to choose which would be better for your needs.

  4. #4
    Join Date
    Jun 2005
    Location
    Waukesha WI
    Posts
    78
    I'm looking for a visual tool to assist in creating the ctl files as well as sql statements between two tables.

    The tool would allow a visual linking of fields with a section where the code could be placed. It would also allow:
    Generate the appropriate statements
    Save the results in a table

    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •