Post reply

Excel to SQL Table data issue

  • October 27, 2010 at 1:13 pm

    #240308

    Hi All,

    I have an issue while bringing data from an Excel to SQL server table. I have 10 columns in Excel and had problem with 2 columns as they are String/Text columns and have string and number values in them. The problem is the package is bringing only character/text values to SQL table but showing NULL values for numbers in those columns. If I have number value (even if the column is set as text in Excel) in first row of data, the SQL server table is loaded with numbers and ignoring text values for those columns.

    I appreciate anyone help for this issue.

    Thanks...

  • October 27, 2010 at 2:28 pm

    #1243184

    Take a look at this: http://microsoftdw.blogspot.com/2005/11/excel-data-not-coming-into-ssis-right.html

    Simply adding the IMEX = 1 to your connection string may solve your problem.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 27, 2010 at 8:41 pm

    #1243280

    It worked for me. Thank you very much.

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

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