Post reply

Importing a csv file into a database - inserts quotes automatically into every field

  • January 22, 2013 at 5:07 am

    #1579566

    can you zip up and attach your solution.

  • January 22, 2013 at 6:21 am

    #1579596

    anthony.green (1/22/2013)

    can you zip up and attach your solution.

    Ok, all seems good apart from the new import connection manager isn't setup for a dynamic connection string.

    1st off give the variable value the path to 1 of the files to import (this is just so it can get the metadata)

    Then...

    Single click the connection manager new import

    Go to the properties window

    Expressions -> elipsis

    Select ConnectionString -> Expression elipsis

    Expand variables

    Drag down @[User::csvLoop] to the expression box

    Then ok all the way out

    hurray!

    that works thanks a lot.

  • January 22, 2013 at 6:22 am

    #1579597

    Not a problem, glad I could assist again.

Viewing 3 posts - 16 through 17 (of 17 total)

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