I am using the same logic......dt_ntext has limit of 2gb

How can i do that in ssis. Can you give me an example.

IN my case i have to create this much xml data . My i am getting this error "XML operation resulted an XML data type exceeding 2GB in size. Operation...

i am having the same problem when attaching database, did u figured it out..

so...did that hurt you...

whats wrong....

the simplest one ....

--create sample data set

declare

@table table (name varchar(100))

insert into @table values ('Apple'),('Melons'),('Orange'),('Mangoes')

--concattinate

declare @nsql nvarchar(max)

set @nsql = ''

select @nsql = @nsql+' '+ name

from @table

select @nsql

In source code find : TablixRowHierarchy

Under : that you will find following piece of code

TablixMember

KeepWithGroupAfter/KeepWithGroup

/TablixMember

Add 2 lines:

RepeatOnNewPagetrue/RepeatOnNewPage

KeepTogethertrue/KeepTogether>

Done

In source code find : TablixRowHierarchy

Under : that you will find following piece of code

1)

2) After

3)

Add 2 lines:

1) true

2) true

New Code :

1)

2) After

3)...

In source code find : TablixRowHierarchy

Under : that you will find following piece of code

After

Add 2 lines:

true

true

New Code :

After

true

true

Done