Post reply

Datatype issue

  • December 5, 2014 at 10:15 am

    #293142

    I have to load excel files in a sql table. In one of the column, some rows has string and some rows have numeric data. When I tried to load it, it only populates string data and populates null for numeric data? Any suggestions?

  • December 5, 2014 at 10:20 am

    #1763025

    It's kind of hard to answer your question without knowing more about the data, the import process, and the table(s).


    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]

  • December 8, 2014 at 6:05 am

    #1763250

    It is really hard to answer without knowing what exactly you are doing. but if you are doing any transformations in DFT then please check the datatypes.. there must be a problem in column datatypes.

    Regards

    Pratiksha

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

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