Post reply

Test connection failed because of an error in initializing provider

  • May 29, 2015 at 2:33 pm

    #318668

    I am new at this SSIS. I know Informatica well. I am creating my first SSIS package, simple, I read a file, a computation and then write it to an excel.

    I am getting the message: "Test connection failed because of an error in initializing provider." The database is NOT remote. My computer is slow though. after about 10 or 15 seconds after clicking the button to test my connection, I get the message and much more. The message asks me if the instance name is correct. I don't know what this would be. This message is on the first task, reading the file (finding the file).

    The last sentence of the long message is: "Named pipes provider: Could not open a connection to SQL Server (2).

    My question is: Why am I getting this message and what do I need to do to resolve this problem?

    Is there any more info I should be giving?

    Shark (and I don't feel like one now)

  • June 4, 2015 at 6:07 pm

    #1803207

    I don't even know how to spell "SSIS" but let me bump this for you. Everyone keeps telling me how easy SSIS is so this should be an easy question for someone to answer. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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