Alister,

Here is the byte count for the 2 tables.

ATReal19672366112 KB

ATSales438612392 KB

Table name, Rows, Columns, Byte count

I figured out how to get byte count.

Thanks

Quinn

I think I figured it out. I used an account with more priveldges than the one I was using. It created the job just fine. Now we will see if...

How do you figure out the byte size of a row? By adding up the bytes of each column?

Thanks

Quinn

Alister,

I am using the ibmdasql provider to extract data from 2 tables on the AS400. I can bring across 24,000 rows in about 30 seconds. That includes deleting the rows...

Tim and Ed,

I got it. I found a thread on the IBM site when I googled the error message I was getting. It had reference to a client side and...

Tim

Thanks again for your help.

I changed the destination like you suggested. I don't have any design time errors but when I run it I get this error:

Error: 0xC0202009 at Extract...

Tim

Thanks for the help. I changed all of the fields from nvarchar to varchar. That helps. I don't have any design mode errors left but when I run the package...

I was able to fix part of the problem. On the source side on the AS400 I changed alwaysusedefaultcodepage to true and that took care of the errors I was...

That did it James.

Thanks

Quinn

Lynn

I was able to get both commands going this morning. I didn't copy far enough down on your CTE solution.

Thanks for all of your patience.

Quinn

Sorry about that.

Yes the data is correct.

Yes

Use the data in the format provided.

Q

I need to summarize acres by ageclass.

Thanks again.

Q

Lynn and all,

I hope I get this right.

Here is the data. It is a paired down set of data.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[timberstands](

[acres] [smallint] NULL,

[curage] [smallint] NULL,

[ctype] [smallint]...

So the final cokmmand is this?

SELECT SUM(acres), CASE

WHEN curage <= 5 THEN 'Age 0-5'

...