Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: Ignoring a Column in During DTS

    I'm importing from an Excel spreadsheet into an SQL Table using DTS.

    Two things:

    1. I don't want anything imported into Column 1 of the table as this has been designed to automatically increment (creating a primary key). I haven't worked out how to do this.

    2. How can I get the DTS package to ignore the top 2 rows of the Excel spreadsheet (header information)?

    An answer to one will be great but both will be tremendous!!

  2. #2
    Join Date
    Oct 2004
    Durban - South Africa
    Hi there,
    Are you using the DTS wizard, or the package designer?
    If at first you don't succeed, call it version 1.0

Posting Permissions

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