Ah yes Lynn, I was wanting to learn cursors back then, not defend my use of them. Cursors are bad RBAR for the most part, but they have their...

When the response from the poster becomes "I don't need that information just focus on the question I asked" when in reality that's what was being done, we all lose...

I looked at the first link (second not redirecting) and now I see why I go here. Same issue and same conclusion but:

1. I would not have recognized it...

Windows 8 Enterprise 64 bit.

This, easy...

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...

opc.three that is fantastic!!! I thought Lynn Petis trumped the topic.

Link works for me too.

I have not yet reproduced your success on my machine and it's the next thing...

So folks, I take it, from the lack of response, that importing from excel columns of data containing all those characters we associate with html source code isn't going to...

anyone have a better idea? Obviously, this isn't feasible long term solution. Clearly the problem is with columns containing the html characters in the problem columns. Need...

I did build it from scratch in BIDS 2010 (did not use import export wizard).

I've attached a sample of my source Excel 97-2003 file, 20 rows and a good portion of the columns including the offending columns: Asset Comments and Asset Description.

shop air compressor - Speedaire State of Washington pressure vessel ID = 33501-03W

looks like browser is converting the characters in my excel from HTML to human readable code. No matter...

David Webb-CDS (5/16/2013)

---

Are you sure it's choking on the destination? In the advanced editor, you might want to check both the external column and the output column on the...

the answer to my registry question is:

To change the value of TypeGuessRows, use these steps: 1.On the Start menu, click Run. In the Run dialog box, type Regedt32, and then...

can you please tell me where I find the registry settings?.....even if that is solution 2? (because this problem is bound to crop up later or another excel source I...

However, some data is flowing now:

Perhaps solution one was the correct solution....and now I have a data length problem?

Error messages:

[Excel Source [14]] Error: There was an error...