IPCCX SQL nvarchar type

[dmanzetti]

Hi all,

using the db get step, if I try to get datas form SQL nvarchar or ntext field the step returns "unsopported object data type".

Now I can't ask to our customer to convert all their databases from nvarchar to char.

Do you know any workaround?

Thanks

Daniele

[smahbub]

Other than converting all the databases from nvarchar to char, I don't know of any other workaround.

[dmanzetti]

I resolved the issue by using DTS on the SQL Server.

I created a scheduled DTS which get datas from the customer table and copy into another table but with varchar data type instead of nvarchar.

Using varchar data type the db_get step works fine.