Post reply

how to load data to server through ssis

  • May 20, 2012 at 10:40 pm

    #261473

    Could you please tell me how to load below mentation data to server through ssis.

    i have used column delimiter , but address filed was created problem

    that why pls tell me any solution.

    Name,Address,rank,Country,col2,col3

    "kiran","Banglore,Karnataka",1,"India",2.0,"Asia"

    "Obul","Banglore,Mumbai",1,"India",2.0,"Asia"

  • May 21, 2012 at 2:06 am

    #1490273

    Because value of Address contains the character "," which is using as column delimiter. You must also define text qualifier with double of single quote in ssis

  • May 22, 2012 at 4:07 am

    #1490954

    Thanks so much.

    It is working fine...

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

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