Addendum, some googled links on the topic:

http://jetlounge.net/blogs/teched/archive/2009/02/03/fix-ssis-script-component-error-quot-the-value-is-too-large-to-fit-in-the-column-data-area-of-the-buffer-quot.aspx

The last post of this:

http://www.sqlbi.com/Default.aspx?tabid=72&forumid=12&threadid=665&scope=posts

These all point to making sure the destination is as large as the source, even with manipulation.

This may help a...

If I'm reading that right it's not the VARCHAR() causing the problem, it's the INT32 field. Something in the source data is one REALLY big number.

GilaMonster (10/29/2010)

---

I've seen someone (who claimed to be a senior DBA) score 0/75 on a DBA technical test where the first question read:

Write a query that returns the FirstName and...

Wut? You want to autogenerate... a timestamp column?

Are you PURPOSELY coding to obfuscate data? What the heck?

If you need a larger identity column, go to bigint.

If you're trying...

Hub/Router fried/shorting? Heartbeat nic cards shorted? I'd look for a physical failure, not a software one, after a massive power failure.

andrew gothard (10/29/2010)

---

Ah - in that case - what I've done in the past is to have the script object parse the filename - set a value in a variable...

Serial/Quirky update in a temp table, a while loop, or possibly a recursion cte. I don't have time right now to convert your data into a usable test structure.

If...

Andrew above has the best 'simple' method. An alternative would be, when this gets more complex, to include a script object and sequence containers that you enable/disable as necessary...

WHERE (@gender = 'B' OR gender = @gender)

Michael Valentine Jones (10/29/2010)

---

You come to work in the morning to find that all the disks in the SAN cabinet were destroyed by a direct lightning hit and none of...

EDIT: That was a dumb idea on further review.... nixing my first comment.

Check this link:

http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/959d46ea-6aec-4c78-a58b-65f95ef00a3f

Seems to have a lot to do with the SQL Server installation, but beyond that, I...

Can you confirm that both the indexing and the data volume are the same between the Test and the Prod servers you're getting different results on?

There's more here than blocking,...

Heh, meant to say the grants themselves aren't the concern, sorry for that.

That is the beginnings of a perfectly good monster, alright, but I'm curious about the wrapper logic. ...

I've been through four, but only managed to find *one* auditor who would actually talk to me. They tend to be incredibly tight lipped, but we smoked together a...

Mymail,

The grant's are the concern, it's the IX (Intent Exclusives) I'm curious about. Beyond that though, the very short description you gave scares the heck out of my inner...