are you getting any errors or warnings when you execute the package? My initial guess is that SSIS is trying to guess the datatypes, and when it sees the first...

Well just walked out of my exam. Passed!! I did find the exam difficult, and I was positive I failed by the end. I would say the transcended materials had...

Great, make sure that none of your values in column2 are longer than 255 characters or they may be truncated. Glad I could help.

-Andrew

actually, you said this was SQL 2000. Not sure if you can do varchar(max)... never worked with 2000. If you get an error converting, try something like varchar(8000) instead

hmm, you could try converting that field in the query

SELECT Column1, CONVERT(varchar(max), Column2), COUNT(Column2) as 'Count'

FROM TableName

GROUP BY Column1, Column2

not sure if you'd need to do that convert inside the...

any reason you are using ntext for column2? Unless you have a good business reason, I'd try switching it to varchar(255)... the 255 represents the max length of the items...

ok, this is a data type issue. Can you provide the data types of your columns?

Hey,

You may have already tried this, but by default I don't think SQL 2008 enables remote connections.

Rright click the server in SSMS and click properties. Select Connections. Make sure...

Hey there,

you should do a group by with both your columns and a count of just the second column. So...

SELECT Column1, Column2, COUNT(Column2) as 'Count'

FROM TableName

GROUP BY Column1, Column2

-Andrew

I agree you should be fine running a 2005 enterprise report server pulling data from 2008 standard db engine. of course if you want to upgrade your report server to...

Thanks for the input.

Exam's tomorrow. I'll post my opinion of how prepared I was tomorrow...

Andrew