Well, I always say I learn something new every day and today is no exception.

The expression builder is not available from the flat-file destination properties window when working inside the...

In the other tread, I posted an article by Kimberly Tripp on partitioning. Re-read the section on partitioning indexes.

You may want to consider partitioning your table (clustered...

I've got a category #6 from the link (invent your own). I have 4 packages that I envoke via Serivce Broker.

How, you might say? Well, the...

Well, it's obvious that this statement is reading messages from a Service Broker queue. What process is running this statement? Is it in a stored procedure somewhere? ...

It's hard to say without trying it. I have enough...

ALZDBA (11/10/2009)

---

That's indeed what I intended to John ! Thank you for stating it more clearly !

btw I wasn't aware you guys did already work on the subject on

anohter...

I assume you are using the ExecuteSQL task? I get the same thing with the .Net connection and the ExecuteSQL task. Try the ODBC connectoin and see what...

Funny Phil, that's the second time in about a week where you've been called sleepy-head!

Try this:

SELECT Manager,

COUNT(Call_Number) AS Total,

SUM(CASE WHEN (Days_Old > 90) AND (Call_Status = 'O') THEN 1 ELSE 0 END) as GT90,

SUM(CASE WHEN (Days_Old < 90) AND (Call_Status = 'O') THEN...

On what?

I think what ALZDBA is getting at is don't get too partition happy. In other thread that you and I worked on, partitioning seemed to...

Well, when I say ODBC, I do mean the Teradata provider. I'm using TDATA32.DLL from NCR Corp. This should be the default Teradata ODBC connection that gets installed...

You can use an ODBC connection with an Execute SQL task to query Teradata from SSIS. Treat it like any other connection and put your SQL statement in the...

Is this for the same database as your other partitioning work? If so, you may consider adding the date column to this table and partitioning everything by date. ...

Why do you need a cursor?

What's wrong with this:

DECLARE @XML_Header xml

SET @XML_Header = (

select distinct

BATCH_NUMBER,

BATCH_ID,

PRODUCT_NUMBER,

SAMPLE_GROUP_ID,

SAMPLE_GROUP_TS,

[USER_NAME],

SAMPLE_ID,

SAMPLE_TS,

TEST_ID,

SAMPLE_VALUE,

COMMENT

FROM DBO.vwGetLineCheckDataForORACLE

FOR XML RAW('item'), ROOT('items'),ELEMENTS , TYPE

)

SELECT @XML_Header

Yes, 1000 is the max # of partitions you can have on a table or index. One thing to consider in partitioning is how many rows you want to...