I am dealing with a similar issue, and found this exerpt in the article referenced below. Check and see if it applies to you:

•Truncated text. When the driver...

Palash Mitra (3/7/2011)

On doing some web searches I have come across suggestions to increase TypeGuessRows doing registry edit.

Ref: http://support.microsoft.com/kb/281517

That KB article says it only applies to...

Ken's query should work. So should this:

DELETE FROM t2

FROM Table_1 t1

RIGHT OUTER JOIN

dbo.Table_2 t2 ON t1.[UNIQUE #] = t2.[UNIQUE #] AND

t1.[SEQ ORDER #] = t2.[SEQ...

When I saw the title of this article, I immediately envisioned replacing:

...WHERE Name LIKE '%son'

with:

WHERE LEFT(REVERSE(Name),3)='nos'

Because to answer the introductory question, "How often do I need to do a search...

I don't know if this will help, but I had the same error on an OLEDB Source component, and I just fixed it by deleting the component and creating a...

I'm doubly fortunate in that I'm an IT worker in South Florida.   Let me tell you, those 1100-page WROX books are total chick-magnets on the beach.

I like using XML for all my .ini file needs.

"A professional game player to give everyone one a break with LAN party or a ping pong game?"

Maybe you should hire a proofreader... 

Damn, somebody already posted my favorite glib answer:   "Google it".

My boss came up with this:

Smash all of the light bulbs and insert a small explosive in...

Julie, if you can afford it, go for it!   The day I got my "ticket" was the highlight of my life, seriously. 

Not that this answers the question, but I just gotta tell you about one of the most uniquely cool perks I've ever gotten at a job.  I went to work...

hehehe... toldya.  

welllll, considering the prevalence of grammatical errors in the article, I'm pretty sure it wasn't genius.   A "happy accident" perhaps.

Also, what does the ASP file do?

Maybe it's something that can be done in a SQL job.

I know where you're coming from.  When I was a beginner and only felt...

I'm not sure if that means you still don't know how or not, but all you do is create a transformation and in the "Source" tab, instead of choosing a...