Post reply

Character encoding for SQL Azure DBD

  • December 27, 2018 at 3:49 am

    #376678

    Hello everyone,So I'm doing an SSIS Package to insert .dat file data into an SQL Azure database.My problem is in the encoding. My files are encoded in ANSI originally. After the execution of my package, the special characters (eg the to is converted to + to).My SSIS package does not work for all lines of my files, especially when I have a varchar (x) and there are x characters in this field.Indeed, since the special character is transferred in 2 characters, so I have, for example, 51 characters instead of 50!Example: "I have a problem with the SSIS Package !!!!!!" which is currently 50 characters long, will be 51 characters long because of the impossibility to insert the line into the SQL Azure table!How to correctly perform my BULK to keep these special characters without having to increase the sizes of my variables ?! (Can not touch the table of my varchar ...)
    .Regards,

  • December 27, 2018 at 6:27 am

    #2017399

    I'm sorry, but I really have no idea what you are trying to say here. What do you mean by "Special characters"? What special characters? Considering that you stated the file is ANSI, then a varchar can happily accept every character.

    When you configure a Flat File connection, you specify the Code page too; did you ensure you selected the right one? It's dulled out in my image, as I haven't selected a file, but you can see it below:

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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