脚本组件转换 [英] Script Component Transformation

问题描述

嗨
请有人告诉我需要输入脚本组件转换的代码才能将三列输入日期转换为10/06/2013英国日期以在平面文件中创建日期格式像这样的目的地10jun2013，我需要显示月份名称？



3列= PD，VD和RD

流程mdb连接管理器到平面文件目的地

我可以使用consolewriteline代码更改格式的日期，使其在平面文件目的地中显示为10Jun2013吗？

转换的哪些选项我还需要select？

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?

推荐答案

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!

这篇关于脚本组件转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！