Dumping MS SQL Server table into XML files.

Papa
Topic Author
Offline
New Member

More

12 years 6 months ago #2210 by Papa

Dumping MS SQL Server table into XML files. was created by Papa

Hi,

I'm dumping MS SQL Server table into XML files.
I want to make sure that all my output date fields looks like
‘2011.03.07’ eg apply format (YYYY.MM.DD)
How can I achieve this in AETL Pro.?

Thanks,
Papa

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

admin
Offline
Administrator
Deeds not Words

More

12 years 6 months ago #2211 by admin

Replied by admin on topic Re: Dumping MS SQL Server table into XML files.

What is your input date format?

Mike

Mike
ETL Architect

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

Papa
Topic Author
Offline
New Member

More

12 years 6 months ago #2212 by Papa

Replied by Papa on topic Re: Dumping MS SQL Server table into XML files.

2011-03-07

Papa

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

admin
Offline
Administrator
Deeds not Words

More

12 years 6 months ago #2213 by admin

Replied by admin on topic Re: Dumping MS SQL Server table into XML files.

That is simple

use replace character function

replace dash with dots

Mike

Mike
ETL Architect

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

ETL-Forum