Script Component Transformation

Question

0.00/5 (No votes)

See more: (untagged)

Hi Please can someone tell me what code I need to enter into a script component transformation in order to convert three columns the input dates reading 10/06/2013 UK date to create a date format in the flat file destination like this 10jun2013 and I need to show the month name?

3 columns = PD, VD and RD
Flow mdb connection manager to flat file destination
Can I use consolewriteline code to change the date for format so it appears like 10Jun2013 in Flat file destination?
What options on the transformation do I also have to select?

Posted 28-Aug-13 0:13am

Member 10237411

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 10237411 · Answer 1 · 2013-08-28T00:21:00

VB

Dim thisDate1 As Date = #6/10/2011#
 Console.WriteLine("Today is " + thisDate1.ToString("MMMM dd, yyyy") + ".")

 Dim thisDate2 As New DateTimeOffset(2011, 6, 10, 15, 24, 16, TimeSpan.Zero)
 Console.WriteLine("The current date and time: {0:MM/dd/yy H:mm:ss zzz}",
                   thisDate2)
 ' The example displays the following output:
'    Today is June 10, 2011.
'    The current date and time: 06/10/11 15:24:16 +00:00

This didn't work for me!

Script Component Transformation

1 solution

Solution 1

Add your solution here

Preview 0

Script Component Transformation

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us