Import Wizard not allowing "Run Immediatly"

  • This is an issue I run into periodically that drives me crazy.

    I am importing an excel sheet to add data to my table and I go through the process pointing to the table and editing mappings.

    All of the ones I map have a yellow triangle with an exclamation point in it. The ones I didn't map have a green circle with a checkmark (these are set as Ignored and not mapped).

    The ones I mapped happen to be all varchars - so shouldn't be a problem.

    Then when I go to the Save and Run, depending on how many I have mapped - I MAY be able to run immediatly. If I map more then about 5, the Run Immediately choice is disabled??????

    If I allow the program to use a new files (which it names the same as the excel file, than it allows me to run immediately.

    Why can't I ALWAYS run immediately???

    Thanks,

    Tom

  • My guess would be that it has to do with security issues and configuration.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • I thought that to.

    But then why would it allow me to run immediately if I map the 1st 4 and then it won't when I map the next one or two.

    Makes no sense.

    And if that is the case, it should tell me something because it makes the tool absolutely worthless.

    If I run into a situation where I need it and can't use it - as I did yesterday - what good is it.

    Thanks,

    Tom

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

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