Export to QV formate convert all data type to text

More
10 years 6 months ago #6751 by mukeshkumar2k8
Hi,

I use ETL Advance Ent Product for exporting data from SQL Server to Qvx formate and it convert all numeric and date field data type to text format.
What should I do ?

Attched is a table exported to Qvx format. Fields like BusinessDate & Total are been converted to text.

Regards
Mukesh

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago - 10 years 6 months ago #6752 by admin
I aussume that you are ussing export package object to generate QVX files.
At the moment it saves everhing as strigs.
We will try to determine field type automaticaly but it will take up to 10 days to do.

Instead of using export object you can transformation object.
With it you can define field's types

see picture attached

PS
If you want to attach something zip it first.

Mike

Mike
ETL Architect
Attachments:
Last edit: 10 years 6 months ago by admin.

Please Log in or Create an account to join the conversation.