Results 1 to 3 of 3

Thread: Dts

  1. #1
    Join Date
    Jul 2004

    Unanswered: Dts

    Hi All,

    I am trying to populate an Oracle table with the data from an Excel spreadsheet using DTS. The Excel spreadsheet has three date fields. When I run DTS one of these three fields is populated correctly and the other two just come over as blank. Any idea?

    Any help is appreciated.

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Whenever importing data, especially from unreliable formats such as Excel, it is wise to load the records into a staging table first, and then use a stored procedure to verify, cleanse, and transfer the data to your production table.
    Make the columns in your staging table NVARCHAR2, so you can see what is actually coming into them, and that will help you debug the situation.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  3. #3
    Join Date
    Apr 2002
    Toronto, Canada
    excel? DTS? SQL Server? oracle? | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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