kellerb (1/24/2011)

---

The other screens are empty. In addition, I am able to run other statements through the same task without error, even the non dynamic version of code from...

See how this works for you:

Sample Data:

IF OBJECT_ID( 'DeFielder') IS NOT NULL

DROP TABLE DeFielder

CREATE TABLE DeFielder

(RowID INT IDENTITY( 1, 1),

FileTypeID INT,

FileData VARCHAR(MAX)

)

ON [PRIMARY]

GO

INSERT INTO DeFielder( FileTypeID, FileData)

SELECT1, '1,2,3,4,5,"abc,def",6,7,"yui,asd"' UNION ALL

SELECT1,...

Can you screen shot the next two windows as well (Parameters and result set)? Or if you can simply confirm they're empty, that would help.

Next troubleshoot would be to...

I wouldn't argue that there's some options available to build some nice front ends for Full Text Indexing.

I would argue these points:

1) We do database here, not front ends. ...

Short answer: You can't. SSIS doesn't allow for dynamic metadata (schema) at runtime.

Longer answer: There are workarounds. Massive Script enable/disable structures on a file by file basis...

*fwip*fwip*fwip*fwip*fwip*CRASH*

Quoth the Craig: Ow...

Grant Fritchey (1/24/2011)

---

Basically, my job is to supply a geek voice for marketing. I'm to write books, articles, blog entries, do web casts, video, voice, present at user groups and...

Don't use replace column in the lookup, create a new one and use Role2 throughout the rest of the script, just carry Role around with it, unused.

Incredibly helpful. It tells us that you have user contextual logic changes that may be occurring.

Here's your next step: Dig down to the deepest call. Find out if...

It shouldn't, so that's confusing. Can you describe more about how you're making the calls? Are you opening up a query window connected to the server with the...

Is google hiring or is this a source forge project?

That's a lot of work and technique that would either need to become opensource, or it's going to end up as...

Hmmm, interesting puzzle.

Ferguson (1/18/2011)

---

Pulled over about 280 million rows from a DB2 database, and dumped them into a table with no indexes at all -- about 58 Gigabytes of data.

Did...

Just to wrap my head around the issue, are we discussing this 2TB issue:

http://blogs.technet.com/b/askcore/archive/2010/02/18/understanding-the-2-tb-limit-in-windows-storage.aspx, which is storage related...

or this one:

http://www.techrepublic.com/blog/datacenter/sql-server-2008-r2-licensing-changes-and-feature-information/2715

Which is RAM/Memory related?

Most significantly, Microsoft has added a Datacenter edition...

These aren't Oracle script errors, but SSIS object errors.

My first thought is to turn BypassPrepare to TRUE.

After that, we'd have to evaluate the properties and settings in the object.

Oh, I agree from a security perspective it's a bit twitchy, but I was looking at it from a maintenance point of view.

Having to rebuild operators for new/old users receiving...