Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007

    Unanswered: DTS to import data

    Hi All,

    I'm working on a DTS to import data from excel files in a SQL database. The thing is, the excel files never have the same structure, meaning, never the same number of columns,sheets as we have to define a destination table and a transformation, do you know a way to do that?

  2. #2
    Join Date
    Jul 2005
    New Zealand

    Allow NULLS

    I think you'll need to get the provider of the Excel file to at least include the field even if it doesn't have any data. Then, if in your destination table you can specify that columns allow NULL values, when you receive a file that doesn't have any data for a particular column in your destination table, it won't matter.
    You could also set a default value on those columns. Are you working with a native Excel file or a CSV file?


Posting Permissions

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