HomeForum
Welcome, Guest
ETL-Forum
Forum
Advanced ETL Processor

Dumping MS SQL Server table into XML files.
(1 viewing) (1) Guest
Reply Topic
New Topic
  • 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
Reply Quote

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
Reply Quote

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
Reply Quote

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
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Advanced ETL Processor
Powered by Kunena
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

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top