SSIS Excel Source and its metadata

  • I'm ready to jump and am hoping someone can talk me down. I have a package that has an excel connection, all of the columns in the excel document are text, when i setup a transformation from excel into a data conversion task and than into sql 2005, the metadata on some of the columns is showing a DT_DATE, i have no clue where its pulling that from, or what its looking @ to determine thats what it should be, but its preventing data from being imported into SQL from the sheet:w00t:.

  • A little more information, we just cant seem to get a column that was once a date column in excel to show up in my import. The column right now is text in excel, a string in the import, and its showing null for all columns that were once dates

  • Hi, if you use the ssis import-export wizzard, there is a sql-task first which creates the destination table. There you can define the layout of your sql-columns

    the statement looks somehow like this:

    CREATE TABLE [MyTable].[dbo].[tblFirmen] (

    [id-DB] decimal(18,0),

    [COMPANY0] nvarchar(100),

    [JuridicalForm] nvarchar(50),

    [STREET0] nvarchar(200),

    [ZIP0] nvarchar(15),

    ....

    )

    GO

    there you should see that some columns are defined as date - you can change the definition to i. e. nvarchar(50).

    Regards,

    Susanne

  • Thanks for the reply, im not even letting it get into the table yet, im just looking @ a preview of the data from the connection, and its showing nulls where i have numbers

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply