HomeForum
Welcome, Guest

Dumping MS SQL Server table into XML files.
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Dumping MS SQL Server table into XML files.

Dumping MS SQL Server table into XML files. 1 year, 1 month ago #2210

  • Papa
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
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

Re: Dumping MS SQL Server table into XML files. 1 year, 1 month ago #2211

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
What is your input date format?

Mike

Re: Dumping MS SQL Server table into XML files. 1 year, 1 month ago #2212

  • Papa
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
2011-03-07

Papa

Re: Dumping MS SQL Server table into XML files. 1 year, 1 month ago #2213

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
That is simple

use replace character function

replace dash with dots

Mike
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

"This [Visual Importer ETL] is such a great help. As expected, it has paid for itself within one week!"

Phill Stive,
Oracle DBA, OU,
Newcaste

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top