• KoldCoffee (5/17/2013)


    opc.three.

    This worked and it brings me a great deal of relief. Thank you.

    I attempted to add the TypeGuessRows property to the excel source connection string hoping to make this a portable solution, like so:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\v-helkr\Documents\MOR ETL\360_PMEquipment.xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1;TYPEGUESSROWS=0\";

    but alas it didn't work.

    It was worth a try but I would have been surprised if it worked. The connection string contains runtime options and TypeGuessRows is only relevant at design-time.

    Only changing in the registry AND restarting the machine before re-running the package worked.

    Which OS? Just curious and others who see this thread later may be interested. I am on x64 Windows 8 and not have to reboot.

    To answer your aside:

    When a topic on sqlservercentral flows the best, is when the those who join genuinely want to help you with the issue at hand. The most knowledgeable contributors here are usually not derailing the topic. The hope is that no one has time for that at least.

    Eh, "best" is subjective, at best 😀 The tangents are why I keep hanging around here and don't spend much time on sites like ask.sqlservercentral.com or SO. Those sites are strictly moderated the way you're describing and frankly I find it a bit off-putting and have seen it stifle the problem solving and learning process. Strict Q&A sites are great for getting quick answers to the easy stuff (like this question might have been a good candidate) but not so great at allowing us to get beneath the surface into the nitty-gritty details of a problem or platform and share what we have learned to solve interesting, difficult or uncommon problems, or even somewhat common problem in a creative way. At any rate, I am happy you got a path to a working solution and are able to move forward on your project.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato