- Posts: 2
- Thank you received: 0
Export to QV formate convert all data type to text
- mukeshkumar2k8
- Topic Author
- Offline
- New Member
-
Less
More
10 years 6 months ago #6751
by mukeshkumar2k8
Export to QV formate convert all data type to text was created 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
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.
10 years 6 months ago - 10 years 6 months ago #6752
by admin
Mike
ETL Architect
Replied by admin on topic Re: Export to QV formate convert all data type to text
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
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
Last edit: 10 years 6 months ago by admin.
Please Log in or Create an account to join the conversation.