Subject: Package blocked on a data conversion

Hello,

Here's my problem:

(SSIS Package on Visual Studio 2005)

In a DataFlow task,

- it starts with a DataReader Source where I make a request on a cube (I
won't put all fields of measures here):

Code:

SELECT {[Measures].[Destinataires],[Measures].[Aboutis]}ON axis(0),
non empty ([Dim Action].[Dim Action].children,
[Dim Domain].[Dim Domain].children) ON axis(1)
FROM [CUBE]

The field formats returned are DT_NTEXT.

- Next, I use a DataConversion to convert all fields in DT_WSTR

- Next, a second DataConversion to convert action and domain fields to
DT_STR and measure fields to DT_I4

- Then I use a script that replaces the null values by zero

- Finally, I store results into a temporary table.


I run this DataFlow task on many data cubes and on some cube the package
lock on the first DataConversion (it stay in yellow state and does nothing
else).

I checked the data returned by the cube and I do not see anything unusual
compared to lines which work.

I also thought to make a conversion directly on my MDX request, but how ...
? Because after some tests, if I change the field formats of my destination
table to nvarchar(Max), I can run my DataFlow without DataConversion. This
method works well but I need to convert this data.

If you have any question or need further explanation, do not hesitate to ask.

Thank you !


remsrock from France