Hi,

I have tried with the below example...

create table abc (a ntext)

insert into abc values ('badbadabdada')

select convert(nvarchar,a),count(*) from abc group by convert(nvarchar,a)

and this works!!

Regards,

Indra Narayan.

Hi,

I jus browsed across and felt this solution would help you out....

To open the Migrated packages in sql2005 follow the below steps:

Sqlserver2005 -> BusinessIntelligenceMgmtStudio ->file->newproject->Integrationservices ->

In the solution explorer, under...